Formula to Count Cells that are NOT empty.

[XxCALLofBOOTYxX]

[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Looking for a formula to count the cells used if it has something in it. Int this case the RESULT would be "8" because there are eight cells with the number "3" in them.

 

[eduzs]

=countif(a2:c4,"<>")

 

[XxCALLofBOOTYxX]

=countif(a2:c4,"<>")

Exactly what i was looking for... Thanks!

 

[MrIfOnly]

Another option: =COUNTA(A2:C4)

Regards,

CJ