On Mar 30, 10:54*am, "T. Valko" wrote:
{=SUM((I12:I20 <"")*(J12:J20<"")*I12:I20)}

Why test for I12:I20 <"" ?

If a cell in col I is empty it will evaluate as 0:

0*(J12<"")*I12 = 0

=SUM((J12:J20<"")*I12:I20)

--
Biff
Microsoft Excel MVP


You're right. Old habits are hard to break.