Another way:

=SUM(SUMIF(B1:B5,{"J",""},A1:A5))


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Idunno Yet" wrote in message
...
I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include
the
criteria "blank". Am I using the right function? If so, where have I
gone
wrong?
A B
1 1.7 J
2 5.3 U
3 5.3 U
4 5.3
5 5.3 U
=SUMIF(B1:B5,J,A1:A5)