View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danielle Danielle is offline
external usenet poster
 
Posts: 31
Default How can I use €ścountif€ť to count BOTH zeros AND blank cells as zer

How can I use €ścountif€ť to count BOTH zeros AND blank cells as zeros?
Wondering if I am unaware of a formula that exists that is less messy than my
formula below to achieve this answer.

I was going to do this: =COUNTBLANK([range]) + COUNTIF([range], 0)

D.