Adding some list items
in [General]
|
Prev: excel 2007 autofilter change to 2003 autofilter functionality?
Next: Data table with inputs from a differente worksheet
From: Jeremy jeremiah.a.reynolds on 19 Apr 2010 14:40 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.
From: Bernard Liengme on 19 Apr 2010 15:19
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Jeremy" <jeremiah.a.reynolds @ gmail.com> wrote in message news:A2BDE66D-A3FE-4BC5-8396-B6BE083218B3(a)microsoft.com... > 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. > |