Sum Index Match Formula help

[riley2606]

Hi,

I am working on email platform scheduling table.
I want a table like the table at the bottom of the post to the side of the table below which has rows of the days where in the adjacent cell I enter a platform name and in the adjacent cell next to it there will be a formula that sum's up the total volume from which platform I enter in the box. There will be a new sum box for each week. It was suggested I could use the index, match or offset formulas in some way but I am yet to figure it out.

		Monday	Tuesday
10-16/07/17	Client Name
	Platform	Platform 1	Platform 2
	Volume	40,000	200,000
	Client Name
	Platform	Platform 5	Platform 3
	Volume	65,000	50,000
	Client Name
	Platform	Platform 1	Platform 2
	Volume	30,000	10,000
	Client Name
	Platform	Platform 3	Platform 4
	Volume	58,000	80,000
17-23/07/17	Client Name
	Platform	Platform 1	Platform 5
	Volume	10,000	40,000
	Client Name
	Platform	Platform 2	Platform 3
	Volume	70,000	10,000
	Client Name
	Platform	Platform 1	Platform 2
	Volume	25,000	40,000
	Client Name
	Platform	Platform 4	Platform 2
	Volume	10,000	30,000

<colgroup><col width="88" style="width:66pt" span="2"> <col width="110" style="width:83pt" span="2"> </colgroup><tbody>
</tbody>

I used =SUMPRODUCT(--($K$5=$C$4:$C$14)*($C$4:$C$14)) on a previous table. I am aware the cell references now don't match. But it worked mostly fine except I needed to have a number on the end of the platform name instead of just some text for it to work.

Day	Platform	Volumes
Monday	Platform 1	0
Tuesday	Platform 2	0
Wednesday		0
Thursday		0
Friday		0
Saturday		0
Sunday		0

<colgroup><col width="145" style="width:109pt"> <col width="110" style="width:83pt" span="2"> </colgroup><tbody>
</tbody>

Also would it be possible to then have the volume cell to be conditionally formatted based on the volume and what platform it is. As different platforms have different daily volumes limit I would want the cell to have multiple conditions but I am also unsure how to do that too.

 

[njimack]

Confirm with ctrl+shift+enter:
=SUM(IF($C$1:$I$1=$K5,IF($C$3:$D$24=$L5,$C$4:$D$25)))