One way


=SUMPRODUCT(--(K20:K80<""),J20:J80)

--


Regards,


Peo Sjoblom


"Jack B" wrote in message
...
Re Excel 97 --------

I want to SUM only the figures in J20:80 (put sum in J81) that do not have
a
blank corresponding cell in K20:80, but I can't figure out the IF
statement.
To clarify, if for instance, K25 is blank, then I don't want J25 included
in
the sum in J81.


Jack