Multiple Countif Sums

D

Darran

I have 2 calculation to find out, one that finds all cells in K:K that have a
time equal to or less than 4:00:00 (4 o clock) and the other that finds the
ones that are equal to or over 4:00:01. Obviously that is easy enough but I
only want to include the ones that have a 1 in the corresponding G:G column.
I have has a search around on here and gone through several sums using
countif, sumproduct, count(if but none are giving out the correct figures.
Can anyone assist?

Thank you in advance
 
A

Ardus Petus

Use SUMPRODUCT.
But SUMPRODUCT does not accept whole columns frerences like G:G.

If you want tu sum values in column I:
=SUMPRODUCT((G1:G65536=1)*(K1:K65536>TIMEVALUE("4:0:0"));I1:I65536)

HTH
 
D

Darran

Spot on, thank you Ardus.

Ardus Petus said:
Use SUMPRODUCT.
But SUMPRODUCT does not accept whole columns frerences like G:G.

If you want tu sum values in column I:
=SUMPRODUCT((G1:G65536=1)*(K1:K65536>TIMEVALUE("4:0:0"));I1:I65536)

HTH
Click to expand...
 
Top