Thread: countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amanda Amanda is offline
external usenet poster
 
Posts: 151
Default countif

I am trying to count the number of "x" in a row in multiple worksheets. This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr 05'!C4:AF4, "x")

Why isn't it working. Please help.

Thanks
Amanda