Sumif / And Formula

[yeoman99]

Hi,

I have a data table as below. I wish to devise a formula to subtotal by Month (e.g. Jan 19) and Cost Type (e.g. Core) combined. For example Core Total for Jan 19 should be £4,742.

Can anyone please advise a SumIf / And formula to automate this in the 2nd table below.

Thanks, Neil

	Core	Core	Core	Core	Additional	Additional
Month	Offshore	Onshore	Warehouse	Office	Ad Hoc	Yard Rentals
Jan-19	£2,371	£4,485	£990	£2,215	£660	£30,000
Jan-19	£2,371	£5,256	£990	£2,000	£660
Feb-19	£300	£4,485	£990	£3,000	£660	£30,000
Feb-19	£3,000	£6,382	£990	£3,552	£660
Feb-19	£2,371	£500	£990	£3,961	£660
Mar-19	£2,235	£7,154	£990	£2,215	£660
Apr-19	£2,371	£4,485	£990	£2,215	£660
May-19	£2,371	£4,485	£990	£3,961	£660
May-19	£2,371	£5,552	£990	£2,215	£660
May-19	£2,371	£4,485	£990	£2,215	£660
Jun-19	£3,001	£5,552	£990	£3,961	£660	£30,000
Total	£25,133	£52,821	£10,890	£31,510	£7,260	£90,000

<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="64" style="width: 48pt;" span="2"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;"> <col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" span="2"> <tbody> </tbody>

	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19
Core Total	x	x	x	x	x	x
Additional Total	x	x	x	x	x	x

<colgroup><col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="64" style="width: 48pt;" span="2"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;"> <col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" span="2"> <tbody> </tbody>

 

[oldbrewer]

A	B	C	D	E	F	G		ROW 1
Month	Offshore	Onshore	Warehouse	Office	Ad Hoc	Yard Rentals					col M
Jan-19	£2,371	£4,485	£990	£2,215	£660	£30,000
Jan-19	£2,371	£5,256	£990	£2,000	£660
Feb-19	£300	£4,485	£990	£3,000	£660	£30,000				row 5		Offshore	b3:b13
Feb-19	£3,000	£6,382	£990	£3,552	£660							Onshore	c3:c13
Feb-19	£2,371	£500	£990	£3,961	£660							Warehouse	d3:d13
Mar-19	£2,235	£7,154	£990	£2,215	£660							Office	e3:e13
Apr-19	£2,371	£4,485	£990	£2,215	£660							Ad Hoc	f3:f13
May-19	£2,371	£4,485	£990	£3,961	£660					ROW 10		Yard Rentals	g3:g13
May-19	£2,371	£5,552	£990	£2,215	£660
May-19	£2,371	£4,485	£990	£2,215	£660
Jun-19	£3,001	£5,552	£990	£3,961	£660	£30,000
Total	£25,133	£52,821	£10,890	£31,510	£7,260	£90,000
								col I
											a lookup table is used with indirect
				row 21			Jan-19	offshore
							£4,742
							formula giving £4742
				=SUMPRODUCT(($A$3:$A$13=$H$21)*(INDIRECT(OFFSET($M$4,MATCH(I21,$M$5:$M$10,0),1))))

<colgroup><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>