Submit from different sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1935719%22%20slang%3D%22en-US%22%3ESubmit%20from%20different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935719%22%20slang%3D%22en-US%22%3ECan%20I%20SUMIF%20from%20different%20sheets%20using%20one%20or%20more%20criteria.%20Not%20do%20SUMIF(sheet1%2C%20%22word%22%2C%20sheet%201)%20%2BSUMIF(sheet%202%2C%20%22word%22%2C%20sheet%202)%20and%20not%20with%20indirect.%20But%20instead%20do%20SUMIF(sheet%201%20%2B%20sheet%202%20%2B%20sheet%203%2C%20%22word%22%2C%20sheet%201%20%2B%20sheet%202%20%2B%20sheet%203)%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1935719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935847%22%20slang%3D%22de-DE%22%3ESubject%3A%20Submit%20from%20different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935847%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883465%22%20target%3D%22_blank%22%3E%40Sta6779%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3ESum%20over%20several%20worksheets%20Example%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EYou%20have%20a%20workbook%20with%20twelve%20worksheets%20-%20one%20for%20each%20month.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EYou%20now%20want%20to%20add%20up%20certain%20cells%20for%20all%20months%20on%20an%20annual%20table.%20How%20to%20proceed%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E1.%20On%20the%20year%20sheet%2C%20select%20the%20cell%20in%20which%20the%20sum%20of%20all%20months%20should%20appear.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E2.%20Then%20click%20the%20%22AutoSum%22%20button%20shown%20in%20the%20following%20figure%20in%20the%20standard%20toolbar.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E3.%20Then%20switch%20to%20the%20sheet%20for%20the%20first%20month%20via%20the%20table%20tab.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EThere%20press%20the%20Shift%20key%20and%20mark%20the%20cell%20that%20is%20to%20be%20added%20from%20all%20tables.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E4th.%20Hold%20down%20the%20Shift%20key%20and%20click%20on%20the%20worksheet%20for%20the%20last%20month%20that%20you%20want%20to%20include%20in%20your%20addition.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E5.%20Now%20release%20the%20Shift%20key%20and%20enter%20the%20Enter%20key.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EIn%20your%20annual%20table%20you%20will%20find%20the%20total%20of%20all%20amounts%20for%20the%20individual%20months%2C%20which%20are%20in%20the%20position%20you%20marked%20in%20your%20first%20sheet.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EFormula%3A%20%3D%20sum%20(startsheet!%20A1%3A%20endsheet!%20A1)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Can I SUMIF from different sheets using one or more criteria. Not do SUMIF(sheet1, "word", sheet 1) +SUMIF(sheet 2, "word", sheet 2) and not with indirect. But instead do SUMIF(sheet 1 + sheet 2 + sheet 3, "word", sheet 1 + sheet 2 + sheet 3)
2 Replies

@Sta6779 

Sum over several worksheets Example:

You have a workbook with twelve worksheets - one for each month.

You now want to add up certain cells for all months on an annual table. How to proceed:

1. On the year sheet, select the cell in which the sum of all months should appear.

2. Then click the "AutoSum" button shown in the following figure in the standard toolbar.

3. Then switch to the sheet for the first month via the table tab.

There press the Shift key and mark the cell that is to be added from all tables.

4. Hold down the Shift key and click on the worksheet for the last month that you want to include in your addition.

5. Now release the Shift key and enter the Enter key.

In your annual table you will find the total of all amounts for the individual months, which are in the position you marked in your first sheet.

Formula: = sum (startsheet! A1: endsheet! A1)

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@Sta6779 

Not exactly such way, but possible. The pattern is here 3D SUMIF for multiple worksheets