Counting number of cells that satisfy a range of conditions

[Wintermelon96]

Hi all,

Really stuck in a project right now - help is much appreciated!!

Let's assume I have 7 columns of data, A/B/C/D/E/F/G.

What I need is (the count of) the number of rows whereby:

Column A must have a value of at least 1.
Column B must be <= Column C minus the sum of Columns D/E/F in the same row.
Column B must be > Column C minus Column G.

Additionally, it would be extra nice if the code would be such that I can drag it to the right and keep everything except Column C (which is in fact on a different sheet, and is the variable that I intend to change horizontally).

I have tried searching for sumproduct / countif functions, but haven't had success. Thanks so much in advance!

Cheers

 

[DanteAmor]

Hi @★ Wintermelon96, welcome to the forum!

I hope this helps you.

=SUMPRODUCT(($A$2:$A$10>=1)*($B$2:$B$10<=(Sheet1!C$2:C$10-($D$2:$D$10+$E$2:$E$10+$F$2:$F$10))*($B$2:$B$10>(Sheet1!C$2:C$10-$G$2:$G$10))))