SUMIF over multiple spreadsheets

Mark234

Junior Member

Posts: 4

Quote:

Originally Posted by Spencer101

Hi Mark,

I'm not 100% sure I understand what you're trying to do on your summary sheet. Could you explain a little more?

Spencer.

The 490240-012 is a list of profit and loss codes - these codes will appear in the individual tabs and I would like to add up the net expense total of 490240-012 and all the other codes each time it appears for each employees tab.

Take a look at the attached, it's what I have just changed around - some of the errors still remain though and not sure why.

Attached Files

exp 3.zip (92.5 KB, 45 views)

Last edited by Mark234 : July 1st 12 at 11:48 AM

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
Update multiple spreadsheets in multiple workbooks	TAP	Setting up and Configuration of Excel	1	October 5th 10 01:36 AM
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter	Greg in CO[_2_]	Excel Worksheet Functions	0	September 18th 08 05:51 PM
SUMIF - counting across different spreadsheets	JoFo	Excel Worksheet Functions	2	July 19th 06 02:47 PM
SUMIF with multiple criteria for multiple columns to sum a single	SavageMind	Excel Programming	1	July 27th 05 03:34 PM
How to update multiple links in multiple spreadsheets followin mo.	Andy	Excel Worksheet Functions	0	January 20th 05 04:51 PM

All times are GMT +1. The time now is 07:12 PM.

Menu

About Us