AC5FF
Registered User.
- Local time
- Yesterday, 21:17
- Joined
- Apr 6, 2004
- Messages
- 552
I really should know the answer to this; but I cannot for the life of me get things to work! Hopefully someone here will know the answer and give me a virtual slap across the face!
I have two columns of data here: One is location (DAV/REW/OTHER) the second is an amount (Dollar Figure). What I want to do is sum all the amounts if it is a DAV amount. Likewize I'll need to do the same with REW and OTHER amounts, but just getting the first one to work will let me know how to do the others...
I tried to use the VLOOKUP function, but it will only return the first line that it finds with "DAV". Any other ideas?
Sample of data:
DAV...$2
DAV...$3
REW...$2
DAV...$9
OTHER...$8
REW...$2
DAV...$3
THANKS!
I have two columns of data here: One is location (DAV/REW/OTHER) the second is an amount (Dollar Figure). What I want to do is sum all the amounts if it is a DAV amount. Likewize I'll need to do the same with REW and OTHER amounts, but just getting the first one to work will let me know how to do the others...
I tried to use the VLOOKUP function, but it will only return the first line that it finds with "DAV". Any other ideas?
Sample of data:
DAV...$2
DAV...$3
REW...$2
DAV...$9
OTHER...$8
REW...$2
DAV...$3
THANKS!