Countif cell is not blank

[Tomo]

I am using the following statement which works fine except sometimes I use the expression 10 + 12 in a cell to show two numbers I want the result to show 2
how do I get the countif to count if the cell is anything other then blank.

=COUNTIF(Tuesday!D9:D11,">0")


Thanks

 

[VoG]

Try

=COUNTA(Tuesday!D9:D11)

 

[Tomo]

Once again you helped me out Cheers

 

[Tomo]

Taking it one step further is it possible to count the 11 + 12 as 2

so c1 =1 show as 1
so c2 =2 show as 1
so c3 = 12 + 13 show as 2
so c4 = 1 show as 1


d1=sum(c1:c4)

 

[VoG]

Sorry, I don't know how to do that.

 

[VoG]

Perhaps with a helper column

Excel Workbook
	A	B
1	1	1
2	2	1
3	2 + 3	2
4		4
Sheet3