Hi,

Getting this SUMPRODUCT forumula to work has me stumped.

For range: $E$3:$E$352 is not blank
For range: $S$3:$S$352 is equal to or greater than $P$3:$P$352 *2 (cells
where P is => 2x S)
SUM Range:$S$3:$S$352

I've come up with this formula, but clearly it does not work:
=SUMPRODUCT(--($E$3:$E$352<>0),(($S$3:$S$352>=($P$3:$P$352*2))),($S$3:$S$352))

Additionally, I need a derivation of this forumula which will count (rather
than sum) the number of cells in S which meet the first two criteria.

I tried this, but it does not work:
=SUMPRODUCT(--($E$3:$E$352<>0),--(($S$3:$S$352>=($P$3:$P$352*2))))

Appreciate any guidance that can be provided.

Thanks,
David