Adding some list items

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

Hello, I have an easy one here that I cannot seem to figure out. I have a
simple list

A:A = Vendor
B:B = Amount
C:C = Category (from dropdown list)

What is the formula to get the sum of only the items in a specific category?
E2 to E9 is the list of the categories. I tried =SUMIF(B:B,$E$2=C2) and it
comes back as zero when B2=1000 and E2 and C2 are the same.

Please help.
 
The syntax of SUMIF is =SUMIF(criteria_range, criteria, sum_range)
The last argument is not needed if the same as the first - this is not your
case
We need to sum the B values for all records having C values equal to E2
=SUMIF(C:C, E2, B:B)
best wishes
 
Back
Top