Enter the criteria <"" in a cell then reference the cell instead of typing
the criteria directly in the formula

B1 contains <""

=SUMIF(A1:C1,B1,A2:C2)

Nick


"David" wrote in message
...
Hi, and TIA for your time.
I've tried SUMIF(A1:C1,"<"""",A2:C2) where the 2nd argument needs to be
'not equal to blank. Please advise on the correct syntax.
Thanks
--
David