If the formula is something like

=SUMIF(A:A,"="&$C13,B:B)

then that just means that B will be summed when the corresponding entry
in A is equal to C13

you could equally use

=SUMIF(A:A,$C13,B:B)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522466