#Value Error with COUNTIF Formula

[SFCChase]

Evidently my brain isn't working today.....

I'm using the formula =IF(D7="","",(COUNTIF(I7:Q7,">="&TODAY()))))/COUNTA(I5:Q5) to result a % of trainings that have not expired as of today.

As long as D7 has a name and I7:Q7 has a date, the formula works fine, but whenever D7 is blank I'm getting a #VALUE error and can't figure out why.

Column D is Text
Cells I5:Q5 are also Text
Cells I7:Q7 are dates
Formula will result a %

Any suggestions are greatly appreciated!

 

[Joe4]

What do these formulas return?

=LEN(D7)
=COUNTA(I5:Q5)

 

[Fluff]

Try it like this

=IF(D7="","",COUNTIF(I7:Q7,">="&TODAY())/COUNTA(I5:Q5))

 

[Joe4]

Try it like this

=IF(D7="","",COUNTIF(I7:Q7,">="&TODAY())/COUNTA(I5:Q5))

Ah yes, I didn't notice that the division was outside of the IF statement, so you were literally trying to divide an empty string by a number.
The placement of those parentheses is important!