View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jfj3rd
 
Posts: n/a
Default CountIF() in Worksheet B while referencing cells in Worksheet A


Hi everyone,

So my title might be the best way to answser my questionb ut I'll give
it a longer description here.

I don't want to clutter worksheetA with hidden fields containing
formulas that I would then call in WorksheetB.

So how do I tell CountIF to calculate specified cells in a different
worksheet?

Your help would be appreciative. I searched through the help file but
just simply don't know what I'd be looking for.

JJ


--
jfj3rd
------------------------------------------------------------------------
jfj3rd's Profile: http://www.excelforum.com/member.php...o&userid=33503
View this thread: http://www.excelforum.com/showthread...hreadid=532987