View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thrlckr Thrlckr is offline
external usenet poster
 
Posts: 3
Default Formula to count cells that contain a number & are not shaded

Hello,

I am trying to get Excel to count up blank (or non-shaded) cells, as well as
cells that contain a "1" in it. Can someone please suggest a formula to do
that? I really need it & an excel "guru" told me it could be done, but he
didn't remember how. Any help would be greatly appreciated.

Thank you!