Hi Anna
use SUMIF for this instead
=SUMIF(A1:A10,"movie",B1:B10)
or with movie in cell C1
=SUMIF(A1:A10,C1,B1:B10)
Cheers
JulieD
"Anna" wrote in message
...
I have a tab with various data entries. Lret call it Enter tab. In the
second
tab (Calculation), I entered Vlookup formula that looks up information in
Enter. Since some of the conditions repeat, I was hoping to use
SUM(VLOOKUP)
to add all those that apply in one cell. But it does not work.
Example
Enter tab:
movie $6
dinner $15
movie $10
Calculation tab:
looks up everything for a movie spend. I used SUM(VLOOKUP), but it does
not
return $16, just $6.
Anybody can help?
Thank you
Anna
|