Percentage of cells that meet certain criteria (logical test)

**ccarver** · 12-13-2010, 12:47 PM

From a list of dates, I am trying to determine from the list of dates, what percentage are true based on the logical test

The logical test is (with D100 representing only one of the MANY cells that I need counted)

=(IF($D100<DATE(YEAR(TODAY())-(1+(MONTH(TODAY())<10)),9,30),"TRUE","FALSE"))

I have tried

=COUNTIF(D88:D115,"(IF<DATE(YEAR(TODAY())-(1+MONTH(TODAY())<10)),9,30"))

I'm not sure how to plug in a logical test into COUNTIF. If somebody has the answer, that would be great. Thank you.

**NBVC** · 12-13-2010, 02:32 PM

Do you mean?

=SUMPRODUCT(--(D88:D115<DATE(YEAR(TODAY())-(1+MONTH(TODAY())<10),9,30)))

or if some of D88:D115 could contain blanks, then:

=SUMPRODUCT(--(D88:D115<DATE(YEAR(TODAY())-(1+MONTH(TODAY())<10),9,30)),--(D88:D115<>""))

**ccarver** · 12-13-2010, 02:57 PM

For some reason it is adding all the dates up instead of just those prior to the date of the formula. Any ideas?

**NBVC** · 12-13-2010, 03:37 PM

Are you sure the dates in column D are actual dates and not text strings looking like dates?

Perhaps post your sample workbook, devoid of confidential info.