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.