View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Another which count function?

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Johnny1r" wrote in message
...
Thans again fella's it worked like a charm. I never thought about just
adding them together, dah!! You guys are great Thanks again John :)

T. Valko wrote:

Try this:

=COUNTIF(A1:E1,"0")+COUNTIF(K1:O1,"0")+COUNTIF(U 1:Y1,"0")