Conditional Formula

[Dsheaff]

Cells H8, H180, and H260 are either blank or contain text. Cells W8, W180, and W260 are to equal the text in cells H8, H180, and H260.... I simply used the formula cell W8=H8, cell W180=H180, and cell W260=H260. When there is no text in cells H8, H180, or H260, the recipient cells are reflecting 0 (zero). Cell W300 is to reflect the number of times cells W8 thru W260 contain text... I used the following formula in recipient cell W300: =COUNTA(W8:W260) When only two of the three cells in the subject range contain text the formula is returning a value or count of 3. I want the return to equal only the number of times text appears in the range.

Help will be greatly appreciated.

 

[Fluff]

Maybe

=COUNTIF(W8:W260,"?*")

 

[Dsheaff]

Maybe

=COUNTIF(W8:W260,"?*")

That did it.. Thanks ever so much!

Dave

 

[Fluff]

You're welcome & thanks for the feedback.