The site is under going some updates, please bear with us while we finish them off.
Any excel experts in da house?
This is a discussion on Any excel experts in da house? within the Off Topic and Chit Chat forums, part of the Members Area category; I'm fairly good with excel usually, but this one has me a little stumped. I have a row of ££ ...
| |||||||
Pronounced "bris-skoda", a brisk skoda. | Register | FAQ | Members List | Calendar | Mark Forums Read |
03-07-2008, 20:55
| #1 |
| Mongreller  Join Date: Apr 2003 Location: Ooo-ar, Oi be from Devonshire
Posts: 29,128
Thanks: 60
Thanked 280 Times in 226 Posts
|  Any excel experts in da house? I'm fairly good with excel usually, but this one has me a little stumped. I have a row of ££ numbers, and in the 2nd column along I have a "YES" for when I have received payment (yes, this is for TRAX  )Basically I want to create a formula down the bottom which will take the ££ figure to the left, IF the column 2 to the right has a YES in it.... Ummm, how? Actually, after thinking more logically for a while I've just done a formula where I've clicked on a cell and hit + and the next cell. I can keep adding to that formula as I go along. PS: NOT ENOUGH PEOPLE HAVE SIGNED UP FOR TRAX! COME ON! 
__________________ Jason - Mongrel owner! WOOOOF! Grrrrr  Custom Fabia Bonnet Lifter Kits - £45! Click Me. See the mongrel's 260bhp Dyno Video!  |
|    |
Find out about Freedom to remove these ads.
|
03-07-2008, 21:01
| #2 |
| Briskodaholic  Join Date: Dec 2004 Location: Fenland, Cambridgeshire
Posts: 10,740
Thanks: 564
Thanked 362 Times in 244 Posts
| Re: Any excel experts in da house? Use the IF command. Click the = sign next to the formula bar, and let the wizard take you through it. E.g. =IF(A2<4,good, bad) where if A2 has a value less than four, then the cell will say good, if more than for then it will say bad.  |
| |
|
03-07-2008, 21:03
| #3 |
| Briskodaholic Join Date: Dec 2004 Location: Fenland, Cambridgeshire
Posts: 10,740
Thanks: 564
Thanked 362 Times in 244 Posts
| Re: Any excel experts in da house? Ignore the above, thats not what you want is it. You need to use a count function I think. Off out now but will have a think when I get back. |
|
| |
|
03-07-2008, 21:22
| #4 |
| Confused!  Join Date: Aug 2006 Location: Wrexham
Posts: 1,147
Thanks: 21
Thanked 32 Times in 30 Posts
| Re: Any excel experts in da house? couldn't you use the sumif feature? ie. =SUMIF(C2:C12,"Yes",B2:B12) I'll admit I'm not 100% sure of what you are trying to do though 
__________________  Golf GT TDI - Standard (at the minute)  |
|
| |
|
03-07-2008, 21:27
| #5 |
| Briskodian  Join Date: Jan 2005
Posts: 12,261
Thanks: 32
Thanked 116 Times in 97 Posts
| Re: Any excel experts in da house? Could you use: "If name column A=yes in column 2(Trax),Pat head,Chase"? Mo
__________________  |
|
| |
|
03-07-2008, 21:31
| #6 |
| Smokey  Join Date: Oct 2004 Location: Around Manchester & Cheshire
Posts: 10,530
Thanks: 363
Thanked 254 Times in 243 Posts
| Re: Any excel experts in da house? Rob's SUMIF should do it for you... Steve
__________________ Wardy's Fabia vRS xenons : sunroof : cruise : OEM+ "Racing is life. Anything before or after is just waiting." - Steve McQueen |
|
| |
|
03-07-2008, 21:35
| #7 | |
| Briskodian Join Date: Jan 2005
Posts: 12,261
Thanks: 32
Thanked 116 Times in 97 Posts
| Re: Any excel experts in da house? Quote:
" was how to derive a formula that would get more people to sign up for Trax... Mo
__________________ | |
|
| |
|
03-07-2008, 21:55
| #8 | |
| Mongreller Join Date: Apr 2003 Location: Ooo-ar, Oi be from Devonshire
Posts: 29,128
Thanks: 60
Thanked 280 Times in 226 Posts
| Re: Any excel experts in da house? Quote:
Forget any of this and I will stick to my simple + "cell ref" each time someone pays.
__________________ Jason - Mongrel owner! WOOOOF! Grrrrr Custom Fabia Bonnet Lifter Kits - £45! Click Me. See the mongrel's 260bhp Dyno Video! | |
|
| |
|
03-07-2008, 22:09
| #9 |
| Confused! Join Date: Aug 2006 Location: Wrexham
Posts: 1,147
Thanks: 21
Thanked 32 Times in 30 Posts
| Re: Any excel experts in da house? are you using actual figures or just '£' signs?? I know you've got it sorted now, but when I was trying to work it out before, I produced a table like the one attached...(I'm a bit bored tonight )
__________________ Golf GT TDI - Standard (at the minute) |
|
| |
|
03-07-2008, 22:42
| #10 |
| Mongreller Join Date: Apr 2003 Location: Ooo-ar, Oi be from Devonshire
Posts: 29,128
Thanks: 60
Thanked 280 Times in 226 Posts
| Re: Any excel experts in da house? No - I was the one who f****d it up Rob. I thought you needed the column with the numbers in the first part, and the column with the YES's in the last part... Have now swapped around having seen your example, and my TRAX template works spot on now. 
__________________ Jason - Mongrel owner! WOOOOF! Grrrrr Custom Fabia Bonnet Lifter Kits - £45! Click Me. See the mongrel's 260bhp Dyno Video! |
|
| |
|
03-07-2008, 23:11
| #11 |
| Confused! Join Date: Aug 2006 Location: Wrexham
Posts: 1,147
Thanks: 21
Thanked 32 Times in 30 Posts
| Re: Any excel experts in da house? glad I could help mate
__________________ Golf GT TDI - Standard (at the minute) |
|
| |
|
04-07-2008, 01:35
| #12 |
| Smokey Join Date: Oct 2004 Location: Around Manchester & Cheshire
Posts: 10,530
Thanks: 363
Thanked 254 Times in 243 Posts
| Re: Any excel experts in da house? 
__________________ Wardy's Fabia vRS xenons : sunroof : cruise : OEM+ "Racing is life. Anything before or after is just waiting." - Steve McQueen |
|
| |
Linear Mode
