Posted to microsoft.public.excel.worksheet.functions

Steve

Posts: n/a

sumif across multiple sheets

I have the following formula that I am trying to use but the result is #VALUE:

=SUMIF(Sheet1:Sheet9!B1,"PMI",Sheet1:Sheet9!A3)

The formula should look in cell B1 of each sheet and if it is equal to "PMI"
sum of the value in cell A3 in each sheet.

What am I doing wrong or is this possible?

Thanks

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
selecting multiple sheets	Shaun	Excel Worksheet Functions	1	August 31st 05 04:09 PM
Printing Multiple sheets	light_life_love	Excel Discussion (Misc queries)	0	August 25th 05 08:52 PM
How do i auto create multiple files from 1 with multiple sheets	Kathy	Excel Worksheet Functions	0	July 26th 05 01:23 AM
Can I unhide multiple sheets at once?	Brockli	Excel Discussion (Misc queries)	1	February 24th 05 07:46 PM
linking multiple sheets to a summary sheet	greg g	Excel Discussion (Misc queries)	1	December 16th 04 07:43 AM

All times are GMT +1. The time now is 10:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us