View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Counting recurring cells

=countif(a1:a100,"total")
or
=countif(a1:a100,"*total*")

Adjust your range to match what you need.

Peter wrote:

The problem is thus:
I am trying to count the volume of cells on a sheet with the value
"total", but I don't know how to!

Does anyone in googleland have any ideas?

Thanks for your help,

Peter


--

Dave Peterson