get total values based on category

**stoey** · 08-28-2012, 12:05 PM

hi,

how can i get the total value based on category? I have enclosed a sample file...

thanks,

stoey

**K m** · 08-28-2012, 12:50 PM

The formula you need is SUMIF

Assume:
A3:A35 Category Range
G3 = Category, ie A, B, C, D and E
B3:B35 and C3:C35 Range of values to be summed

Then the formula for H3 is:
=SUMIF($A$3:$A$35,G3,$B$3:$B$35)+SUMIF($A$3:$A$35,G3,$C$3:$C$35)

Copy the formula down

Example: Look in range A3:A35 for category "A"
If there is a match, sum the values in ranges B$3:$B$35 and $C$3:$C$35

**stoey** · 08-28-2012, 12:55 PM

wow thanks KM... yeah it worked well but will this also work if say I would only get the value of column B based on my sample by using the formula?:

=SUMIF($A$3:$A$35,G3,$B$3:$B$35)

**K m** · 08-28-2012, 01:04 PM

Not sure what you're asking but yes it should work.

I amended my response, see if you understand it after reading the new response

---------- Post added at 01:03 PM ---------- Previous post was at 12:57 PM ----------

This formula sums only column B

=SUMIF($A$3:$A$35,G3,$B$3:$B$35)

========================================
This formula sums only column C

=SUMIF($A$3:$A$35,G3,$c$3:$c$35)[COLOR="Silver"]

---------- Post added at 01:04 PM ---------- Previous post was at 01:03 PM ----------

Be sure to change the title as [SOLVED] is this answers your question. Be sure to click on the star at the bottom of this post

**stoey** · 08-28-2012, 01:13 PM

well i tried =SUMIF($A$3:$A$35,G3,$B$3:$B$35) and it didn't work...the values on column based on the category were not added...

sorry if i sounded confusing...the formula you gave me will provide the total sum from both column B and C based on the category...i tried getting the sum from column B only...

---------- Post added at 12:10 PM ---------- Previous post was at 12:08 PM ----------

well i tried =SUMIF($A$3:$A$35,G3,$B$3:$B$35) and it didn't work...the values on column based on the category were not added...

sorry if i sounded confusing...the formula you gave me will provide the total sum from both column B and C based on the category...i tried getting the sum from column B only...

---------- Post added at 12:13 PM ---------- Previous post was at 12:10 PM ----------

thanks KM this thread is solved...