How to ignore a cell with a formula that is blank with a countifs formula

[ensmith]

In cell A2 i am trying to ignore the blank cells with formulas in my countifs formula.
=IF(C2="Completed",100%,COUNTIFS(D2:H2,"<>")/5)

 

[Fluff]

How about

=IF(C2="Completed",100%,COUNTIFS(D2:H2,"><")/5)

 

[ensmith]

How about

=IF(C2="Completed",100%,COUNTIFS(D2:H2,"><")/5)

Thanks

How about

=IF(C2="Completed",100%,COUNTIFS(D2:H2,"><")/5)

 

[Fluff]

You're welcome & thanks for the feedback.

 

[etaf]

Hi Fluff, what does the "><" do - is that do not count numbers or spaces - Just TEXT - as searching didnt find an answer and seems thats what it does in this thread application and also testing in a spreadsheet - but just wanted to be sure before adding to my list of things

 

[Fluff]

I can't remember how or why it works, but it will only count text & ignore numbers, anything that starts with a space & also null strings.

 

[etaf]

Thanks for the info
Made a note useful bit of code