SUMIFS Multiple Tabs

[nihad]

Hi all

I have below Spreadsheet, on the Total Summary tab I want to sum all other tabs in this summary tab for Example on B25 I want to sum all the "food" cost from tab October, so my criteria will be in column A


Here is is my Summary Tab

Hospitality Report.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1		Crosfields
2
3
4	October	Food	Other Soft Drinks/Food	Liquor	Disp	Equipment	Sundry	Agency Labour	Labour	VAT	Total
5	Breakfast
6	Parent Events
7	Pupil Match Teas
8	Parent Match Teas
9	Marketing
10	Other Events
11	Governors
12	Staff Room
13	Total	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -
14
15								Total Labour	£ -
16
17								Total Costs ex.VAT	£ -
18
19								Gross Total	£ -
20
21		Crosfields
22
23
24		Food	Other Soft Drinks/Food	Liquor	Disp	Equipment	Sundry	Agency Labour	Labour	VAT	Total
25	October
26	November
27	December
28	January
29	February
30	March
31	April
32	May
33	June
34	July
35	August
36	September
37	YTD Total	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -
38
39								Total Labour	£ -
40
41								Total Costs ex.VAT	£ -
42
43								Gross Total	£ -
44
45	Crosfields
46
47
48		Breakfast	Parent Events	Pupil Match Teas	Marketing	Parent Match Teas	Other Events	Governors	Staff Room	Total
49	October
50	November
51	December
52	January
53	February
54	March
55	April
56	May
57	June
58	July
59	August
60	September
61	YTD Total	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -	£ -
Total Summary

Cell Formulas
Range	Formula
B1	B1	=Template!E2
B13:K13	B13	=SUM(B5:B12)
I15,I39	I15	=SUM(H13:I13)
I17,I41	I17	=SUM(K13)
I19,I43	I19	=J13+K13
B21	B21	=Template!E2
B37:K37,B61:J61	B37	=SUM(B25:B36)
A45	A45	=Template!E2

secondly on B5 I want to sumif column "I" based on column "F"

Hospitality Report.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
6		Date of event	Booked by	Purpose of Event	Internal Order Details	Hospitality Type	No. of Covers	Cost per head	Food	Other Soft Drinks or food	Liquor	Disposables	Equipment	Sundry	Agency Labour	Extra Labour	VAT allocated	NET TOTAL
7	1					Breakfast			£ 25.00								£ -	£ 25.00
8	2					Parent Events			£ 10.00								£ -	£ 10.00
9	3					Breakfast			£ 10.00								£ -	£ 10.00
10	4					Breakfast			£ 5.00								£ -	£ 5.00
11	5					Breakfast			£ 25.00								£ -	£ 25.00
12	6																£ -	£ -
October

Cell Formulas
Range	Formula
B6:H6,J6:R6	B6	=Template!B6
Q7:Q12	Q7	=SUM((K7+L7+M7+N7+O7)*20%)
R7:R12	R7	=SUM(I7:Q7)

Cells with Data Validation
Cell	Allow	Criteria
F7:F12	List	=Data!$A$1:$A$8

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: SUMIFS Multiple sheets
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[nihad]

Hi Fluff

Sorry I needed this bit urgently that is why I cross posted

Here is the link to my other post SUMIFS Multiple sheets