Dynamically updating formula

[tpitt813]

In the displayed sheet, I would like to update the formulas in the range c3:d8 with the appropriate cell range based on the month entered in C1. This is the formula in C3
=SUMPRODUCT(('Circ Chrgs'!$H$2:$H$240="BR")*('Circ Chrgs'!$I$2:$I$240="RING")*('Circ Chrgs'!$N$2:$N$240))
These are the 'month' references
jan Circ Chrgs'!$t$2:$t$240
feb Circ Chrgs'!$u$2:$u$240
mar Circ Chrgs'!$v$2:$v$240
apr Circ Chrgs'!$w$2:$w$240
may Circ Chrgs'!$x$2:$x$240
jun Circ Chrgs'!$y$2:$y$240
jul Circ Chrgs'!$n$2:$n$240
aug Circ Chrgs'!$o$2:$o$240
sep Circ Chrgs'!$p$2:$p$240
oct Circ Chrgs'!$q$2:$q$240
nov Circ Chrgs'!$r$2:$r$240
dec Circ Chrgs'!$s$2:$s$240

I will appreciate any help.

DSS Circuit Charges.xls
	A	B	C	D	E	F
1			jul
2		POPSITE	RING COST	BACK COST	TAIL COUNT	TAIL SHARE
3		BR	12,872.70	26,760.65	155	255.70
4		LAF	9,765.55	1,901.50	30	388.90
5		MON	10,099.20	1,976.50	33	365.93
6		NO	0.00	10,050.00	34	295.59
7		SH	9,760.85	2,001.50	21	560.11
8		WDL	840.00	0.00	34	24.71
Calc

 

[Domenic]

Try...

C3, copied down and across:

=SUMPRODUCT(--('Circ Chrgs'!$H$2:$H$240=$B3),--('Circ Chrgs'!$I$2:$I$240=C$2),INDEX('Circ Chrgs'!$N$2:$Y$240,0,MATCH($C$1,{"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"},0)))

Hope this helps!

Edited formula...

 

[tpitt813]

Thanks a million. This works like a charm!

 

[Domenic]

Thanks a million. This works like a charm!

Your very welcome! Notice, though, that I've edited the formula so that the formula can be copied down the column and across...