Help with a Workbook issue

[NoelJ]

Good morning
I have a workbook which has 9 individual Dept sheets to record travel costs. I am looking for help in calculating the total monthly cost on each sheet and transfering that figure into the correct month on the summary sheet.

Travel Costs - Dept 1
Month	Bus	Train	Taxi	Flights	Car Hire	Total Cost
Apr	10	42		195		247
Apr	8		15			23
Apr	3	2				5
May		13			66	79
May	2					2
May		26		352		378
Jun	5		25			30
Jun	7	25	16		45	93
Jul	15					15
Jul	8	9		198		215
Jul	3		24			27
Aug	6	21				27
Aug	4			75	93	172
Sept	9	13				22
Sept		14				14
Sept	8	65		29		102
Sept	2	22	42			66

<colgroup><col width="64" style="width:48pt" span="7"> </colgroup><tbody>
</tbody>

Monthly Total Cost - Summary Sheet
Dept	Apr	May	Jun	Jul	Aug	Sep
Dept 1
Dept 2
Dept 3
Dept 4
Dept 5
Dept 6
Dept 7
Dept 8
Dept 9
I am trying to search for the correct month entries, total them then transfer that figure to the summary sheet. Is this possible or am I asking the impossible? I have tried IF,SUMIF,DGET and VLOOKUP but nothing seems to work, but that could be me! Could you help at all? Many thanks

<colgroup><col span="7"></colgroup><tbody>

</tbody>

 

[Fluff]

How about

Book1
	A	B	C	D	E	F	G
1	Month	Bus	Train	Taxi	Flights	Car Hire	Total Cost
2	Apr	10	42		195		247
3	Apr	8		15			23
4	Apr	3	2				5
5	May		13			66	79
6	May	2					2
7	May		26		352		378
8	Jun	5		25			30
9	Jun	7	25	16		45	93
10	Jul	15					15
11	Jul	8	9		198		215
12	Jul	3		24			27
13	Aug	6	21				27
14	Aug	4			75	93	172
15	Sept	9	13				22
16	Sept		14				14
17	Sept	8	65		29		102
18	Sept	2	22	42			66
Travel Costs - Dept 1

Book1
	A	B	C	D	E	F	G
1	Dept	Apr	May	Jun	Jul	Aug	Sep
2	Dept 1	275	459	123	257	199	0
3	Dept 2
4	Dept 3
5	Dept 4
6	Dept 5
7	Dept 6
8	Dept 7
9	Dept 8
10	Dept 9
Summary

Cell Formulas
Range	Formula
B2	=SUMIF(INDIRECT("'Travel Costs - "&$A2&"'!A:A"),B$1,INDIRECT("'Travel Costs - "&$A2&"'!G:G"))

 

[NoelJ]

Hey, this is fantastic! thanks for your help

NoelJ

 

[Fluff]

You're welcome & thanks for the feedback