Excel CountIf formula is counting the formula, help!

[kdorning]

I have multiple cells with formulas that pull from other sheets and if there is no result, I have it returning blank. I am trying to get a count of cells with values (not blanks) but apparently the formula is counting both.

Base formula to populate cells: =IF('Reviewer 3'!F1="","",'Reviewer 3'!F1)
Formula to count the non-blank cells: =COUNTIFS(D2:F2,"<>")

The base formulas return two values and one blank (correctly) but the second formula is returning "3". HELP!

Below are the formulas and the results. (I am only concerned with rows D-G, specifically the response in G2.

 

[Sufiyan97]

IGNOR

Book2
	A	B	C	D	E
1		Reviewer #1	Reviewer #2	Reviewer #3
2		Name	Name		2
Sheet1

Cell Formulas
Range	Formula
E2	E2	=COUNTIF(B2:D2,"*")

 

[Fluff]

How about

=COUNTIFS(D2:F2,"?*")