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:

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl94, width: 64"]Enrolled in Medical?[/TD]
[TD="class: xl95, width: 64"]Age[/TD]
[TD="class: xl93, width: 64"]CB PPO Platinum $0 w/ EA[/TD]
[/TR]
[TR]
[TD="class: xl91"]Y[/TD]
[TD="class: xl91"]62[/TD]
[TD="class: xl83"]$1,077.63[/TD]
[/TR]
[TR]
[TD="class: xl84"]Y[/TD]
[TD="class: xl84"]59[/TD]
[TD="class: xl88"]$976.36[/TD]
[/TR]
[TR]
[TD="class: xl85"]Y[/TD]
[TD="class: xl85"]56[/TD]
[TD="class: xl89"]$875.08[/TD]
[/TR]
[TR]
[TD="class: xl84"]Y[/TD]
[TD="class: xl84"]45[/TD]
[TD="class: xl88"]$541.63[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]42[/TD]
[TD="class: xl90"]$496.99[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]13[/TD]
[TD="class: xl90"]$305.67[/TD]
[/TR]
[TR]
[TD="class: xl85"]Y[/TD]
[TD="class: xl85"]15[/TD]
[TD="class: xl89"]$331.18[/TD]
[/TR]
[TR]
[TD="class: xl84"]Y[/TD]
[TD="class: xl84"]39[/TD]
[TD="class: xl88"]$473.36[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]47[/TD]
[TD="class: xl90"]$586.27[/TD]
[/TR]
[TR]
[TD="class: xl85"]Y[/TD]
[TD="class: xl85"]15[/TD]
[TD="class: xl89"]$331.18[/TD]
[/TR]
[TR]
[TD="class: xl84"]Y[/TD]
[TD="class: xl84"]47[/TD]
[TD="class: xl88"]$586.27[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]47[/TD]
[TD="class: xl90"]$586.27[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]20[/TD]
[TD="class: xl90"]$363.84[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]14[/TD]
[TD="class: xl90"]$305.67[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]17[/TD]
[TD="class: xl90"]$350.68[/TD]
[/TR]
[TR]
[TD="class: xl85"]Y($0)[/TD]
[TD="class: xl85"]5[/TD]
[TD="class: xl89"]$0.00[/TD]
[/TR]
[TR]
[TD="class: xl84"]Y[/TD]
[TD="class: xl84"]40[/TD]
[TD="class: xl88"]$479.37[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]40[/TD]
[TD="class: xl90"]$479.37[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]13[/TD]
[TD="class: xl90"]$305.67[/TD]
[/TR]
[TR]
[TD="class: xl85"]Y[/TD]
[TD="class: xl85"]14[/TD]
[TD="class: xl89"]$305.67[/TD]
[/TR]
[TR]
[TD="class: xl84"]Y[/TD]
[TD="class: xl84"]41[/TD]
[TD="class: xl88"]$488.37[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]41[/TD]
[TD="class: xl90"]$488.37[/TD]
[/TR]
[TR]
[TD="class: xl86"]Y[/TD]
[TD="class: xl86"]10[/TD]
[TD="class: xl90"]$305.67[/TD]
[/TR]
[TR]
[TD="class: xl85"]Y[/TD]
[TD="class: xl85"]6[/TD]
[TD="class: xl89"]$305.67[/TD]
[/TR]
[TR]
[TD="class: xl82"]Y[/TD]
[TD="class: xl82"]27[/TD]
[TD="class: xl88"]$393.09[/TD]
[/TR]
[TR]
[TD="class: xl80"]Y[/TD]
[TD="class: xl80"]28[/TD]
[TD="class: xl90"]$407.72[/TD]
[/TR]
[TR]
[TD="class: xl87"]Y[/TD]
[TD="class: xl87"]0[/TD]
[TD="class: xl92"]$305.67[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl81"]$12,453[/TD]
[/TR]
</tbody>[/TABLE]

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.