Summing based on a range of criteria
 

If I have the number "1" in cells A1 through A5 and the number "2" in cells
A6 through A9 and then I have various dollar values in cells B1 through B9,
how can I sum the items in cells B1 through B5 because they have the same
number (in this case "1") in cells A1 through A5? Likewise, how can I sum
the values in cells B6 through B9 because they have the same value in cells
A6 through A9 (in this case "2")? What function is there that would allow me
to compare the values in column A in order to sum the values in column B?
Can someone show me the syntax? Assume that I have 2000+ plus rows that need
to have the comparison and subsequent summing completed.

Summing based on a range of criteria
 

Hi

Try using this in C1

=SUMIF(A1:A9,1,B1:B9)

this will give you the sum of value with condition as 1
chnage the condition to 2

or you can use a cell reference

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Mike" wrote:

If I have the number "1" in cells A1 through A5 and the number "2" in cells
A6 through A9 and then I have various dollar values in cells B1 through B9,
how can I sum the items in cells B1 through B5 because they have the same
number (in this case "1") in cells A1 through A5? Likewise, how can I sum
the values in cells B6 through B9 because they have the same value in cells
A6 through A9 (in this case "2")? What function is there that would allow me
to compare the values in column A in order to sum the values in column B?
Can someone show me the syntax? Assume that I have 2000+ plus rows that need
to have the comparison and subsequent summing completed.

Summing based on a range of criteria
 

=sumif(a1:A99,1,b1,b99)

excel will return the sum of amounts on column b if you have a 1 in column A
hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Mike" escreveu:

If I have the number "1" in cells A1 through A5 and the number "2" in cells
A6 through A9 and then I have various dollar values in cells B1 through B9,
how can I sum the items in cells B1 through B5 because they have the same
number (in this case "1") in cells A1 through A5? Likewise, how can I sum
the values in cells B6 through B9 because they have the same value in cells
A6 through A9 (in this case "2")? What function is there that would allow me
to compare the values in column A in order to sum the values in column B?
Can someone show me the syntax? Assume that I have 2000+ plus rows that need
to have the comparison and subsequent summing completed.

Summing based on a range of criteria
 

Use SUMIF

if Col A contains numerics
=sumif(A1:A2000,1,B1,B2000)

since you have mentioned this as *** "1" **** if Col A is text
=sumif(A1:A2000,"1",B1,B2000)


If this post helps click Yes
---------------
Jacob Skaria


"Mike" wrote:

If I have the number "1" in cells A1 through A5 and the number "2" in cells
A6 through A9 and then I have various dollar values in cells B1 through B9,
how can I sum the items in cells B1 through B5 because they have the same
number (in this case "1") in cells A1 through A5? Likewise, how can I sum
the values in cells B6 through B9 because they have the same value in cells
A6 through A9 (in this case "2")? What function is there that would allow me
to compare the values in column A in order to sum the values in column B?
Can someone show me the syntax? Assume that I have 2000+ plus rows that need
to have the comparison and subsequent summing completed.