Sounds like you want the COUNTA function...

=COUNTA(C3:D500)

Just set the range reference as needed.

--
Rick (MVP - Excel)


" wrote in message
...
what formula will count cells that contain any randmon data
text number, just basicly it will return a count for a range of cell
that are not empty