Want to do COUNTIF if length of cell is greater than 0

[doofusboy]

Looking for formula syntax and drawing a blank....any assistance appreciated!

something like = COUNTIF(MyRangeName,if individual cell length > 0)

 

[Silverback1992]

No, see below:

Sheet1

*	A	B	C	D
*	*
a	*	*	*
*	*	*	*
*	*	*	*
*	*	*	*
*	*	*	*
*	*	*	*
*	*	*	*
*	*	*	*
*	*	*	*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: right"]-7[/TD]
[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula A1 ="" C1 =COUNTA(A1:A10)-COUNTBLANK(A1:A10) D1 =SUMPRODUCT(--(A1:A10<>"")) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >>

Ah yes, Thank you I dont know why I didnt think of that.