Possible Sumifs with Hlookup/match

[Blcook6383]

What I am hoping to do is actually more complicated than what I am currently asking. I am hoping I have simplified this enough so that it can make sense to someone who is not looking at the entire worksheet. Here is a screen shot of a portion of a single tab I want to refer to:

Enrolled in Medical?	Age	CB PPO Platinum $0 w/ EA
Y	62	$1,077.63
Y	59	$976.36
Y	56	$875.08
Y	45	$541.63
Y	42	$496.99
Y	13	$305.67
Y	15	$331.18
Y	39	$473.36
Y	47	$586.27
Y	15	$331.18
Y	47	$586.27
Y	47	$586.27
Y	20	$363.84
Y	14	$305.67
Y	17	$350.68
Y($0)	5	$0.00
Y	40	$479.37
Y	40	$479.37
Y	13	$305.67
Y	14	$305.67
Y	41	$488.37
Y	41	$488.37
Y	10	$305.67
Y	6	$305.67
Y	27	$393.09
Y	28	$407.72
Y	0	$305.67
		$12,453

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

The formula for determining the rate found in J6 can be "IF($A2="Y",HLOOKUP($C$1,'Q318 N rate grids'!$A$1:$GY$77,MATCH($B$2,'Q318 N rate grids'!$A$1:$A$77,0),FALSE),0)"

I want to actually replace this grid and produce the total price of $12,453. I need to keep the other rate grids and require the first 2 columns as they will change regularly. I've been attempting to build this by utilizing sumifs and am open to using VBA as I am an intermediate user of it. Any help is appreciated.

 

[Blcook6383]

J6 should be C2

 

[Blcook6383]

I also want to amend "I want to actually replace this grid and produce the total price of $12,453. I need to keep the other rate grids and require the first 2 columns as they will change regularly."

I want to replace all of the third column except for the top and produce the total price of $12,453 at the bottom. I need to keep the other rate grids I am referencing and require the first 2 columns as they will change regularly.

This is my first post, sorry for any confusion.