View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SteveT[_2_] SteveT[_2_] is offline
external usenet poster
 
Posts: 1
Default How to count non-empty cells

I have a range of cells with various values (dates, letter N, letter P). I
want to count the number of cells within the range that don't have the letter
N. I don't want to add contents, just get the number of cells that contain a
value. Can someone tell me how this is done?
--
-----------
Thanks,
Steve