{=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


"Ziggy" wrote in message
...

Here is an array formula that works.

Data

100 300
100 300
100 300
100
100
100
100
100 300
100 300

500 Result

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

Enter as Array with Ctrl-Shift-Enter

Siegfried