=SUMPRODUCT(--(K20:K80<""),J20:J80)
or
=SUMPRODUCT((K20:K80<"")*J20:J80)
--
David Biddulph

Jack B wrote:
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