CountIF Q
 

I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks

CountIF Q
 

=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))
--
David Biddulph

"Sean" wrote in message
oups.com...
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks

CountIF Q
 

Try,

=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))

Mike

"Sean" wrote:

I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks

CountIF Q
 

On Sep 19, 8:58 am, Mike H wrote:
Try,

=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))

Mike



"Sean" wrote:
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks- Hide quoted text -

- Show quoted text -

Thanks Guys

CountIF Q
 

On Sep 19, 8:58 am, Mike H wrote:
Try,

=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))

Mike



"Sean" wrote:
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks- Hide quoted text -

- Show quoted text -

Slight twist on above, how could I count If (C7:C377,"<0") AND
(C7:C377,"4"))

In other words Count times values are between 1-4?

CountIF Q
 

On Sep 19, 9:07 am, Sean wrote:
On Sep 19, 8:58 am, Mike H wrote:





Try,

=SUMPRODUCT((A7:A377<TODAY())*(C7:C377=0))

Mike

"Sean" wrote:
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks- Hide quoted text -

- Show quoted text -

Slight twist on above, how could I count If (C7:C377,"<0") AND
(C7:C377,"4"))

In other words Count times values are between 1-4?- Hide quoted text -

- Show quoted text -

Worked it

=SUMPRODUCT(($A7:$A377<TODAY())*(C7:C3770)*(C7:C3 77<4))

CountIF Q
 

try:
=SUMPRODUCT((A1:A10<TODAY())*(B1:B10=0))
or
{=sum((A1:A10<TODAY())*(B1:B10=0))}

HTH

Regards
Sebation.g
"Sean"
groups.com...
I have dates listed in Column A7:A377. How can I incorporate this
formula =COUNTIF(C7:C377,"=0") to count only if the Dates in A7:A377
are less than TODAY()

Thanks