Multiple Countif Sums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif, index and match 2
Excel Need Countifs Formula Help 0
Countif time syntax 6
Countif and Time fields 3
Help with countifs 1
Pivot table calculated field Count(field) / sum(field) 0
COUNTIF using amount of time 3
Countif and Right functions 8

Back
Top