Posted to microsoft.public.excel.newusers

Rob

external usenet poster

Posts: 718

Countif in multiple worksheets

I have a workbook, with multiple (70) sheets , each with it's own name. Each
sheet states in cell D2 "Yes", "No", or "Not sure". In a summary worksheet I
would like to count the number of times "yes" has been stated in cell D2 of
all worksheets. With COUNTF I can't get the range right. Is it possible to do
this? I sure could use some help, thanx

Rob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Using Countif with multiple worksheets	Countif error	Excel Worksheet Functions	5	July 25th 08 06:44 PM
countif function in multiple worksheets	ferde	New Users to Excel	3	February 23rd 06 09:19 PM
Help with countif on multiple worksheets	jeremed	Excel Worksheet Functions	2	July 8th 05 12:59 AM
Countif multiple worksheets	Natalie	Excel Worksheet Functions	4	March 8th 05 12:35 PM
Countif with multiple criteria and multiple worksheets	JJ	Excel Worksheet Functions	1	December 28th 04 06:37 PM

All times are GMT +1. The time now is 01:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us