Posted to microsoft.public.excel.misc

onlyinsyder onlyinsyder is offline

external usenet poster

Posts: 9

COUNTIF Formula in Multiple worksheets.

I need to use the COUNTIF formula to count items in 52 different worksheets.
I know that this formula will not work in counting multiple worksheets.
Anyone know of a quick workaround?
I dont want to get stuck typing 52 different SUM formulas.

Thanks,
Brent

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
Copying a formula to multiple worksheets	RobHan	Excel Worksheet Functions	1	February 16th 06 05:21 PM
Adding same cells across multiple worksheets	LACA	Excel Worksheet Functions	2	January 19th 06 03:21 PM
Adding multiple worksheets	Craig	Excel Worksheet Functions	1	July 6th 05 07:21 PM
Countif multiple worksheets	Natalie	Excel Worksheet Functions	4	March 8th 05 12:35 PM
Countif formula with multiple criteria ie >30 and <60?	Dali	Excel Worksheet Functions	2	January 7th 05 04:49 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us