Posted to microsoft.public.excel.misc

Fritz

external usenet poster

Posts: 29

Sumif on multiple worksheets

Hi I have a formula below that I want to expand to more than one worksheet.
I've played with indirect from other examples but I just don't get it right.

In a summary worksheet I want to bring this total in for all worksheets.
=SUMIF('23050'!B2:B166,"*3220*",'23050'!C2:C166)

the other worksheets are called
23060,23070,23080,23100,23110,23120,23130,23140

I want to expand this to other references than "*3220*" which I'm fine with
but not sure how to use the indirect correctly to cover all the worksheets.

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
SUMIF across multiple worksheets	Fgbdrum	Excel Discussion (Misc queries)	5	October 20th 06 06:29 PM
SumIf across multiple worksheets	ChrisM	Excel Worksheet Functions	4	September 22nd 06 04:20 PM
Sumif Across multiple worksheets	Giantrobot	Excel Worksheet Functions	2	June 15th 06 08:28 PM
Sumif across multiple worksheets	Ted Metro	Excel Worksheet Functions	2	December 19th 05 10:40 PM
Sumif with multiple worksheets	Cbh35711	Excel Worksheet Functions	3	August 9th 05 02:49 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us