I am sorry, but yes this is wrong. The way SUMIF works is as follows:

=SUMIF(RANGE,REF,SUMCOL)

RANGE = the range of cells you are looking through
REF = the vairable you are looking for
SUMCOL = the column / range you are summarizing

So.... Given the folowing,

A B
1 1001 50
2 1002 40
3 1003 20
4 1004 30
5 1001 10
6 1003 20

AND the formula =SUMIF(A1:A6,1001,B1:B6)

your result would be "60"


Hope this helps!


--
sseavert
------------------------------------------------------------------------
sseavert's Profile: http://www.excelforum.com/member.php...o&userid=33579
View this thread: http://www.excelforum.com/showthread...hreadid=533912