Thanks for the reply. Looks like the forum didn't take my pic. Below is a table that may help.
I have the formula flushed out, except for only summing criteria that matches in A2 to A7:A23. Thanks!
<colgroup><col style="mso-width-source:userset;mso-width-alt:914;width:19pt" width="25"> <col style="mso-width-source:userset;mso-width-alt:3876;width:80pt" width="106"> <col style="mso-width-source:userset;mso-width-alt:3840;width:79pt" width="105"> <col style="mso-width-source:userset;mso-width-alt:6619;width:136pt" width="181"> <col style="mso-width-source:userset;mso-width-alt:7570;width:155pt" width="207"> </colgroup><tbody>
[TD="class: xl67, width: 25"] [/TD]
[TD="class: xl68, width: 106"]A[/TD]
[TD="class: xl68, width: 105"]B[/TD]
[TD="class: xl68, width: 181"]C[/TD]
[TD="class: xl68, width: 207"]D[/TD]
[TD="class: xl67"]1[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]2[/TD]
[TD="class: xl69"]B-Sys-Grp[/TD]
[TD="class: xl67"]
FORMULA HERE
[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]3[/TD]
[TD="class: xl69"]Nano-Tracker[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]4[/TD]
[TD="class: xl69"]Super Chargers[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]
[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]5[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"]6[/TD]
[TD="class: xl70"]Program[/TD]
[TD="class: xl71, width: 105"]Project-ID[/TD]
[TD="class: xl71, width: 181"]Task ID[/TD]
[TD="class: xl71, width: 207"]Costs[/TD]
[TD="class: xl67"]7[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]36[/TD]
[TD="class: xl67"]284[/TD]
[TD="class: xl73"] $ 2,000 [/TD]
[TD="class: xl67"]8[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]36[/TD]
[TD="class: xl67"]286[/TD]
[TD="class: xl73"] $ 2,000 [/TD]
[TD="class: xl67"]9[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]36[/TD]
[TD="class: xl67"]287[/TD]
[TD="class: xl73"] $ 2,000 [/TD]
[TD="class: xl67"]10[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]73[/TD]
[TD="class: xl67"]403[/TD]
[TD="class: xl73"] $ 1,720 [/TD]
[TD="class: xl67"]11[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]73[/TD]
[TD="class: xl67"]404[/TD]
[TD="class: xl73"] $ 1,720 [/TD]
[TD="class: xl67"]12[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]37[/TD]
[TD="class: xl67"]428[/TD]
[TD="class: xl73"] $ 400 [/TD]
[TD="class: xl67"]13[/TD]
[TD="class: xl72"]B-Sys-Grp[/TD]
[TD="class: xl72"]37[/TD]
[TD="class: xl67"]429[/TD]
[TD="class: xl73"] $ 400 [/TD]
[TD="class: xl67"]14[/TD]
[TD="class: xl72"]Nano-Tracker[/TD]
[TD="class: xl72"]102[/TD]
[TD="class: xl67"]846[/TD]
[TD="class: xl73"] $ 2,469 [/TD]
[TD="class: xl67"]15[/TD]
[TD="class: xl72"]Nano-Tracker[/TD]
[TD="class: xl72"]861[/TD]
[TD="class: xl67"]1039[/TD]
[TD="class: xl73"] $ 373 [/TD]
[TD="class: xl67"]16[/TD]
[TD="class: xl72"]Nano-Tracker[/TD]
[TD="class: xl72"]861[/TD]
[TD="class: xl67"]1040[/TD]
[TD="class: xl73"] $ 373 [/TD]
[TD="class: xl67"]17[/TD]
[TD="class: xl72"]Nano-Tracker[/TD]
[TD="class: xl72"]861[/TD]
[TD="class: xl67"]1042[/TD]
[TD="class: xl73"] $ 373 [/TD]
[TD="class: xl67"]18[/TD]
[TD="class: xl72"]Nano-Tracker[/TD]
[TD="class: xl72"]875[/TD]
[TD="class: xl67"]1048[/TD]
[TD="class: xl73"] $ - [/TD]
[TD="class: xl67"]19[/TD]
[TD="class: xl72"]Super Chargers[/TD]
[TD="class: xl72"]65[/TD]
[TD="class: xl67"]943[/TD]
[TD="class: xl73"] $ 1,866 [/TD]
[TD="class: xl67"]20[/TD]
[TD="class: xl72"]Super Chargers[/TD]
[TD="class: xl72"]65[/TD]
[TD="class: xl67"]944[/TD]
[TD="class: xl73"] $ 1,866 [/TD]
[TD="class: xl67"]21[/TD]
[TD="class: xl72"]Super Chargers[/TD]
[TD="class: xl72"]65[/TD]
[TD="class: xl67"]946[/TD]
[TD="class: xl73"] $ 1,866 [/TD]
[TD="class: xl67"]22[/TD]
[TD="class: xl72"]Super Chargers[/TD]
[TD="class: xl72"]68[/TD]
[TD="class: xl67"]753[/TD]
[TD="class: xl73"] $ 2,083 [/TD]
[TD="class: xl67"]23[/TD]
[TD="class: xl72"]Super Chargers[/TD]
[TD="class: xl72"]68[/TD]
[TD="class: xl67"]757[/TD]
[TD="class: xl73"] $ 2,083 [/TD]
</tbody>