Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 52

SUM/COUNTIF across multiple worksheets

Hello All,

I have a 50 worksheet file that has a summary on each page that I would like
to summarize again on a summary page into broader categories. The summary
value is a formula in a merged cell and right now I have
=SUM('R5:R10'!AV5:AW11)/COUNTIF('R5:R10'!AV5:AW11,"0"). The problem is when
I add in values it doesn't change the number for me.

Any idea what I am doing wrong?

Any help would be greatly appreciated.

Thanks,

B

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
Countif in multiple worksheets	Rob	New Users to Excel	6	January 22nd 09 06:32 PM
Using Countif with multiple worksheets	Countif error	Excel Worksheet Functions	5	July 25th 08 06:44 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 07:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us