Do you use commas as a list separator or semi colon. If semi colon, change
the formula to

=SUMIF(Sheet1!B:B; A1; Sheet1:C:C)

in either case, make sure the formula is not located in column B or C.

--
Regards,
Tom Ogilvy


"VB123" wrote in
message ...

Excel isn't recognizing that formula. It says there is an error in my
formula and highlights 3dsumif. Is there something special I need to
do?


--
VB123
------------------------------------------------------------------------
VB123's Profile:
http://www.excelforum.com/member.php...o&userid=28166
View this thread: http://www.excelforum.com/showthread...hreadid=476893