Multiple Countif Sums

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
--
AP

"Darran" <Darran@discussions.microsoft.com> a écrit dans le message de news:
0F693F70-11EB-4B41-A7D4-9F279FA5C5D7@microsoft.com...
>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

Spot on, thank you Ardus.

"Ardus Petus" wrote:

> 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
> --
> AP
>
> "Darran" <Darran@discussions.microsoft.com> a écrit dans le message de news:
> 0F693F70-11EB-4B41-A7D4-9F279FA5C5D7@microsoft.com...
> >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
>
>
>