Totaling VLookup

[jhillman]

I am trying to get a total of items in a list by category using vlookup.
I have a list of 20 different transactions, there might be 8 of them that
are one specific category and I want those to total. My current Vlookup
formula is this: =(VLOOKUP($I3,$C$3:$E$15,2,FALSE)) and this gives me the
first amount in my array, but I want it to give me a total of all amounts in
my array with the specific category.

 

[Luke M]

Wrong function. Try this:

=SUMIF($C3:$C15,$I3,$D3:$D15)

 

[Pete_UK]

Try this instead:

=SUMIF($C$3:$C$15,$I3,$D$3:$D$15)

Hope this helps.

Pete