Totaling VLookup
 

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.

Totaling VLookup
 

Wrong function. Try this:

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

Luke M
*Remember to click "yes" if this post helped you!*


"jhillman" wrote:

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.

Totaling VLookup
 

Try this instead:

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

Hope this helps.

Pete

On Nov 30, 4:53*pm, jhillman
wrote:
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.