sum only certain figures in the column
 

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

sum only certain figures in the column
 

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

sum only certain figures in the column
 

=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