LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Location: I live in Riverside, work in Anahiem
Posts: 1
Send a message via ICQ to jfj3rd Send a message via MSN to jfj3rd Send a message via Yahoo to jfj3rd
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

Last edited by jfj3rd : April 14th 06 at 06:32 PM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make multiple cells in 1 worksheet equal multiple cells in another riley454 Excel Worksheet Functions 1 January 19th 06 03:00 PM
How can I use open/close Grouped cells in a Protected Worksheet? Andy Bowshell Excel Discussion (Misc queries) 2 January 16th 06 02:38 PM
linking cells in one worksheet to cells in another worksheet NKirkland Excel Worksheet Functions 2 January 12th 06 03:46 PM
Reference cells from another worksheet problem Neil Excel Discussion (Misc queries) 3 June 23rd 05 05:24 PM
How can I merge unlocked cells in a worksheet that has been protec NeedMergeHelp Excel Discussion (Misc queries) 2 December 7th 04 01:20 AM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"