Posted to microsoft.public.excel.misc

frustratedwthis

Posts: n/a

SUMIF with multiple sheets

I am trying to use the following formula to sum the same cell on multiple
sheets IF the critria in another cell on each sheet matches :

=SUMIF('06-01:06-92'I6,NP,'06-01:06-92I8)

I get a return of VALUE.
Can I not use SUMIF to calculate the numbers I need?
Any suggestions?

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 01:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us