Thread: Countif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Countif

Sure.

=countif(a2:i25,"apple")
will still count the number of cells that equal Apple even if there are empty
cells in that range.

But I'm guessing that something isn't working for you.

Any chance you have extra spaces in those cells with Apple in them?

M.A.Tyler wrote:

Can you use a range of cells, A2:I25, that includes blank cells and still
count the instances of "apple"?


--

Dave Peterson