AutoSum random cells

[Loin75]

Hi,

I have this formula which counts how many rows have value "0" in column A, and a value higher than 10 in column B. It works great.

=SUMPRODUCT((B3:B500>10)*(A3:A500={"0"}))

I now need to do the same, but this time ADD all the values that are found in column B of those rows.

i.e. All those values over 10 (in column B) AND with a value of "0" in column A, need to be accumulated for one final figure.

Is this possible please...?

 

[Richard Schollar]

Hi

Like this?

=SUMPRODUCT((B3:B500>10)*(A3:A500="0"),B3:B500)

 

[Loin75]

Perfect, thank you...