Hi Domenic

I tried using the following function,

=SUMPRODUCT((A2:A6="Dividend")*(A2:A6="Interest")* (B2:D6)) with the table
below and I get a value of zero. I was expecting 1200.

Jan Feb March
Dividend 100 100 100
Interest 100 100 100
Expenses -100 -100 -100
Dividend 100 100 100
Interest 100 100 100


Thanks.


"Domenic" wrote:

Sure...

=SUMPRODUCT((RangeA="Criterion")*(RangeB="Criterio n")*(RangeC="Criterion"
)*(RangeToSum))

Remove the quotes if your criterion is a numerical value.

Hope this helps!

In article ,
"nc" wrote:

Thanks Domenic.

Can this function be adapted to use more than one criteria.