Avoid counting blank cells!

[martinsimart]

Hi all

I have a spreadsheet with dates entered against issues we have at work

I wanted a count of the number of issues that are 90 days older than today's date

this code: =SUMPRODUCT(--(C1:C10<TODAY())) counts number of dates but also counts blank cells

so my challenge is to avoid counting blank cells and how to include the 90 days citeria

I have tried numerous ways but no joy, should I be using COUNTIF?

thanks in advance

 

[mabalo76]

try countifs

=COUNTIFS(A:A,"<="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))-90)

 

[Joe4]

It looks like your formula is getting cut off. That often happens when it mistakes > or < signs for HTML code.
Try posting your formula again, but put spaces on BOTH side of any > or < signs that you have.

 

[mabalo76]

or just use simplified countif

=COUNTIF(A:A,"<="&TODAY()-90)

 

[martinsimart]

thanks everyone

mabalo76, your formula worked a treat. In hindsight I can see the logic of using COUNTIF rather than SUMPRODUCT (in this case)

cheers