COUNTIF Function issue
 

I need to make a count if function which will count the cell in a column if
the date in that column meets the following condition

TODAY()-A190

A1 in this formula represents the the Cell being referenced in a column of
60 dates I need to know how many of those dates are more than 90 days old.
Thanks in advance for any help

COUNTIF Function issue
 

more than 90 days old.

Try this:

=SUMPRODUCT(--(A1:A60<TODAY()-90))

--
Biff
Microsoft Excel MVP


"Gweduc" wrote in message
...
I need to make a count if function which will count the cell in a column if
the date in that column meets the following condition

TODAY()-A190

A1 in this formula represents the the Cell being referenced in a column of
60 dates I need to know how many of those dates are more than 90 days old.
Thanks in advance for any help

COUNTIF Function issue
 

=SUMPRODUCT(--(A1:A60<TODAY()-90))
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Gweduc" wrote in message
...
I need to make a count if function which will count the cell in a column
if
the date in that column meets the following condition

TODAY()-A190

A1 in this formula represents the the Cell being referenced in a column of
60 dates I need to know how many of those dates are more than 90 days old.
Thanks in advance for any help

COUNTIF Function issue
 

=SUMPRODUCT(--(A1:A60<TODAY()-90),--(A1:A60<""))

"Gweduc" wrote:

I need to make a count if function which will count the cell in a column if
the date in that column meets the following condition

TODAY()-A190

A1 in this formula represents the the Cell being referenced in a column of
60 dates I need to know how many of those dates are more than 90 days old.
Thanks in advance for any help

COUNTIF Function issue
 

Thanks for your help with this, it worked very well.

Sid


"T. Valko" wrote:

more than 90 days old.

Try this:

=SUMPRODUCT(--(A1:A60<TODAY()-90))

--
Biff
Microsoft Excel MVP


"Gweduc" wrote in message
...
I need to make a count if function which will count the cell in a column if
the date in that column meets the following condition

TODAY()-A190

A1 in this formula represents the the Cell being referenced in a column of
60 dates I need to know how many of those dates are more than 90 days old.
Thanks in advance for any help

COUNTIF Function issue
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Gweduc" wrote in message
...
Thanks for your help with this, it worked very well.

Sid


"T. Valko" wrote:

more than 90 days old.

Try this:

=SUMPRODUCT(--(A1:A60<TODAY()-90))

--
Biff
Microsoft Excel MVP


"Gweduc" wrote in message
...
I need to make a count if function which will count the cell in a column
if
the date in that column meets the following condition

TODAY()-A190

A1 in this formula represents the the Cell being referenced in a column
of
60 dates I need to know how many of those dates are more than 90 days
old.
Thanks in advance for any help