Sum If Is Not Summing Horizontally

[Guzzlr]

=SUMIF(B2:B4,B2,F2:J2)

Hello All, I ran into an issue using SUMIF. The formula above only pulls the number in F2. I want the SUMIF to sum horizontally, instead of vertically.
I thought it would sum horizontally?
thanks

 

[oldbrewer]

[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]130[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]28[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]is this what you want as output ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Guzzlr]

[TABLE="width: 768"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]14[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]17
[/TD]
[TD="align: right"]18
[/TD]
[TD="align: right"]19
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]21
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]130[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]28[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]is this what you want as output ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Not exactly, the criteria column would be something like 2,3,4. If the criteria was 2, it would be 60, if the criteria was 3 it would be 95.
There would be multiple criteria 2 down the single column of B:B, all adding Column F:N, based upon Criteria 2 every time the criteria 2 would be found in Column B:B.
Criteria 3 in Column B:B would add column F:N everywhere Criteria 3 was found in Column B:B
Thanks for the help

 

[Scott Huish]

SUMIF can sum horizontally, but your criteria range is vertical and your sum range is horizontal which is what is causing the problem.

Is this what you want?

=SUMPRODUCT((B2:B4=B2)*F2:J4)

Excel 2010
	B	C	D	E	F	G	H	I	J
2	2				10	11	12	13	14
3	3				17	18	19	20	21
4	2				24	25	26	27	28
5
6
7			190
Sheet1

Cell Formulas
Range	Formula
D7	=SUMPRODUCT((B2:B4=B2)*F2:J4)

 

[Guzzlr]

<colgroup><col style="width:48pt" width="64" span="9"> </colgroup><tbody>
[TD="class: xl70, width: 64"]Type[/TD]
[TD="class: xl70, width: 64, align: right"]12/27[/TD]
[TD="class: xl70, width: 64, align: right"]1/3[/TD]
[TD="class: xl70, width: 64, align: right"]1/10[/TD]
[TD="class: xl70, width: 64, align: right"]1/17[/TD]
[TD="class: xl70, width: 64, align: right"]1/24[/TD]
[TD="class: xl70, width: 64, align: right"]1/31[/TD]
[TD="class: xl70, width: 64, align: right"]2/7[/TD]
[TD="class: xl70, width: 64, align: right"]2/14[/TD]

[TD="class: xl69"]BCWS[/TD]
[TD="class: xl71"]633.9[/TD]
[TD="class: xl71"]635.7[/TD]
[TD="class: xl71"]750.3[/TD]
[TD="class: xl71"]716.0[/TD]
[TD="class: xl72"]710.92[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]BCWP[/TD]
[TD="class: xl71"]49.9[/TD]
[TD="class: xl71"]569.5[/TD]
[TD="class: xl71"]1568.3[/TD]
[TD="class: xl71"]1307.5[/TD]
[TD="class: xl72"]898.43[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]ACWP[/TD]
[TD="class: xl71"]232.5[/TD]
[TD="class: xl71"]336.6[/TD]
[TD="class: xl71"]1502.0[/TD]
[TD="class: xl71"]1422.3[/TD]
[TD="class: xl72"]1000.80[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]BCWS[/TD]
[TD="class: xl71"]635.2[/TD]
[TD="class: xl71"]714.4[/TD]
[TD="class: xl71"]1874.0[/TD]
[TD="class: xl71"]1663.9[/TD]
[TD="class: xl72"]1245.52[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]BCWP[/TD]
[TD="class: xl71"]188.7[/TD]
[TD="class: xl71"]378.5[/TD]
[TD="class: xl71"]1686.0[/TD]
[TD="class: xl71"]1391.4[/TD]
[TD="class: xl72"]1615.24[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]ACWP[/TD]
[TD="class: xl71"]157.5[/TD]
[TD="class: xl71"]275.0[/TD]
[TD="class: xl71"]1314.3[/TD]
[TD="class: xl71"]1644.4[/TD]
[TD="class: xl72"]1488.80[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]BCWS[/TD]
[TD="class: xl71"]472.2[/TD]
[TD="class: xl71"]451.2[/TD]
[TD="class: xl71"]1301.9[/TD]
[TD="class: xl71"]1155.8[/TD]
[TD="class: xl72"]1157.61[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]BCWP[/TD]
[TD="class: xl71"]67.2[/TD]
[TD="class: xl71"]121.0[/TD]
[TD="class: xl71"]828.7[/TD]
[TD="class: xl71"]659.5[/TD]
[TD="class: xl72"]760.44[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl69"]ACWP[/TD]
[TD="class: xl71"]78.9[/TD]
[TD="class: xl71"]98.7[/TD]
[TD="class: xl71"]794.1[/TD]
[TD="class: xl71"]725.5[/TD]
[TD="class: xl72"]843.70[/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]

[TD="class: xl70"]Type[/TD]
[TD="class: xl70, align: right"]12/27[/TD]
[TD="class: xl70, align: right"]1/3[/TD]
[TD="class: xl70, align: right"]1/10[/TD]
[TD="class: xl70, align: right"]1/17[/TD]
[TD="class: xl70, align: right"]1/24[/TD]
[TD="class: xl70, align: right"]1/31[/TD]
[TD="class: xl70, align: right"]2/7[/TD]
[TD="class: xl70, align: right"]2/14[/TD]

[TD="class: xl69"]BCWS[/TD]
[TD="class: xl74"]1741[/TD]
[TD="class: xl74"]1801[/TD]
[TD="class: xl74"]3926[/TD]
[TD="class: xl74"]3536[/TD]
[TD="class: xl74"]3114[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]

[TD="class: xl69"]BCWP[/TD]
[TD="class: xl74"]306[/TD]
[TD="class: xl74"]1069[/TD]
[TD="class: xl74"]4083[/TD]
[TD="class: xl74"]3358[/TD]
[TD="class: xl74"]3274[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]

[TD="class: xl69"]ACWP[/TD]
[TD="class: xl74"]469[/TD]
[TD="class: xl74"]710[/TD]
[TD="class: xl74"]3610[/TD]
[TD="class: xl74"]3792[/TD]
[TD="class: xl74"]3333[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]
[TD="class: xl74"]0[/TD]

</tbody>

This is what I'm building so I can make a chart based upon BCWS, BCWP, ACWP numbers. so the totals sum each of the 3 criteria.
Thanks

 

[Fluff]

Are those the values that you want?
As from that layout you seem to adding the values vertically not horizontally.

 

[oldbrewer]

[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Type[/TD]
[TD="class: xl22, width: 64, align: right"]Dec-27[/TD]
[TD="class: xl23, width: 64, align: right"]01-Mar[/TD]
[TD="class: xl23, width: 64, align: right"]01-Oct[/TD]
[TD="class: xl22, width: 64, align: right"]Jan-17[/TD]
[TD="class: xl22, width: 64, align: right"]Jan-24[/TD]
[TD="class: xl22, width: 64, align: right"]Jan-31[/TD]
[TD="class: xl23, width: 64, align: right"]02-Jul[/TD]
[TD="class: xl22, width: 64, align: right"]Feb-14[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]BCWS[/TD]
[TD="align: right"]633.9[/TD]
[TD="align: right"]635.7[/TD]
[TD="align: right"]750.3[/TD]
[TD="align: right"]716[/TD]
[TD="align: right"]710.92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWP[/TD]
[TD="align: right"]49.9[/TD]
[TD="align: right"]569.5[/TD]
[TD="align: right"]1568.3[/TD]
[TD="align: right"]1307.5[/TD]
[TD="align: right"]898.43[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACWP[/TD]
[TD="align: right"]232.5[/TD]
[TD="align: right"]336.6[/TD]
[TD="align: right"]1502[/TD]
[TD="align: right"]1422.3[/TD]
[TD="align: right"]1000.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWS[/TD]
[TD="align: right"]635.2[/TD]
[TD="align: right"]714.4[/TD]
[TD="align: right"]1874[/TD]
[TD="align: right"]1663.9[/TD]
[TD="align: right"]1245.52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWP[/TD]
[TD="align: right"]188.7[/TD]
[TD="align: right"]378.5[/TD]
[TD="align: right"]1686[/TD]
[TD="align: right"]1391.4[/TD]
[TD="align: right"]1615.24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACWP[/TD]
[TD="align: right"]157.5[/TD]
[TD="align: right"]275[/TD]
[TD="align: right"]1314.3[/TD]
[TD="align: right"]1644.4[/TD]
[TD="align: right"]1488.8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWS[/TD]
[TD="align: right"]472.2[/TD]
[TD="align: right"]451.2[/TD]
[TD="align: right"]1301.9[/TD]
[TD="align: right"]1155.8[/TD]
[TD="align: right"]1157.61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWP[/TD]
[TD="align: right"]67.2[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]828.7[/TD]
[TD="align: right"]659.5[/TD]
[TD="align: right"]760.44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACWP[/TD]
[TD="align: right"]78.9[/TD]
[TD="align: right"]98.7[/TD]
[TD="align: right"]794.1[/TD]
[TD="align: right"]725.5[/TD]
[TD="align: right"]843.7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Type[/TD]
[TD="class: xl22, align: right"]Dec-27[/TD]
[TD="class: xl23, align: right"]01-Mar[/TD]
[TD="class: xl23, align: right"]01-Oct[/TD]
[TD="class: xl22, align: right"]Jan-17[/TD]
[TD="class: xl22, align: right"]Jan-24[/TD]
[TD="class: xl22, align: right"]Jan-31[/TD]
[TD="class: xl23, align: right"]02-Jul[/TD]
[TD="class: xl22, align: right"]Feb-14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWS[/TD]
[TD="align: right"]1741[/TD]
[TD="align: right"]1801[/TD]
[TD="align: right"]3926[/TD]
[TD="align: right"]3536[/TD]
[TD="align: right"]3114[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWP[/TD]
[TD="align: right"]306[/TD]
[TD="align: right"]1069[/TD]
[TD="align: right"]4083[/TD]
[TD="align: right"]3358[/TD]
[TD="align: right"]3274[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACWP[/TD]
[TD="align: right"]469[/TD]
[TD="align: right"]710[/TD]
[TD="align: right"]3610[/TD]
[TD="align: right"]3792[/TD]
[TD="align: right"]3333[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWS[/TD]
[TD="align: right"]1741.3[/TD]
[TD="align: right"]1801.3[/TD]
[TD="align: right"]3926.2[/TD]
[TD="align: right"]3535.7[/TD]
[TD="align: right"]3114.05[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BCWP[/TD]
[TD="align: right"]305.8[/TD]
[TD="align: right"]1069[/TD]
[TD="align: right"]4083[/TD]
[TD="align: right"]3358.4[/TD]
[TD="align: right"]3274.11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACWP[/TD]
[TD="align: right"]468.9[/TD]
[TD="align: right"]710.3[/TD]
[TD="align: right"]3610.4[/TD]
[TD="align: right"]3792.2[/TD]
[TD="align: right"]3333.3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]my lower table uses this simple formula[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]in B20 to the right of BCWS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]=SUMPRODUCT(($A$2:$A$10=$A20)*(B$2:B$10))[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]dragged across and down[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Maybe:

=SUM(INDEX(F2:J4,MATCH(B2,B2:B4,0),0))

 

[Guzzlr]

Are those the values that you want?
As from that layout you seem to adding the values vertically not horizontally.

Correct, currently I'm having to add each criteria vertically, one column at at time. I was trying to add horizontally, and vertically. I havent tried the other suggestions yet...ill get to that later today I hope.
thanks for the help