Conditional Sum?

[vasishta1729]

I am trying to perform a conditional sum for something similar to the following data. I have some part numbers in the first column and the weeks in the first row and some data. What I am looking for is, for each month, if the data values start in that month, I want the sum of "Total".

So, for January, I want the sum of Total of ABCD, EFGH, IJKL, MNOP (data values are starting in January). For February, the result would be sum of Totals of QRST, UVWX (data values are starting in February) and for March, the result would be sum of Totals of YZAA and so on.


[TABLE="width: 792"]
<colgroup><col><col><col span="3"><col span="2"><col span="2"><col span="3"></colgroup><tbody>[TR]
[TD]Part Number [/TD]
[TD="align: right"]1/5/2015[/TD]
[TD="align: right"] 1/12/2015[/TD]
[TD="align: right"] 1/19/2015 [/TD]
[TD="align: right"]1/26/2015 [/TD]
[TD="align: right"]2/2/2015 [/TD]
[TD="align: right"]2/9/2015[/TD]
[TD="align: right"] 2/16/2015[/TD]
[TD="align: right"] 2/23/2015[/TD]
[TD="align: right"] 3/2/2015[/TD]
[TD="align: right"] 3/9/2015[/TD]
[TD] Total[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD="align: right"]267[/TD]
[TD="align: right"]267[/TD]
[TD="align: right"]267[/TD]
[TD="align: right"]267[/TD]
[TD] [/TD]
[TD="align: right"]267[/TD]
[TD="align: right"]267[/TD]
[TD="align: right"]267[/TD]
[TD] [/TD]
[TD="align: right"]267[/TD]
[TD="align: right"]2136[/TD]
[/TR]
[TR]
[TD]EFGH[/TD]
[TD="align: right"]2388.75[/TD]
[TD] [/TD]
[TD="align: right"]2388.75[/TD]
[TD="align: right"]2388.75[/TD]
[TD="align: right"]2388.75[/TD]
[TD="align: right"]2388.75[/TD]
[TD] [/TD]
[TD="align: right"]2388.75[/TD]
[TD="align: right"]2388.75[/TD]
[TD="align: right"]2388.75[/TD]
[TD="align: right"]19110[/TD]
[/TR]
[TR]
[TD]IJKL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]7.08[/TD]
[TD="align: right"]26.45[/TD]
[TD] [/TD]
[TD="align: right"]26.79[/TD]
[TD] [/TD]
[TD="align: right"]131[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]191.32[/TD]
[/TR]
[TR]
[TD]MNOP[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]120.45[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]120.45[/TD]
[/TR]
[TR]
[TD]QRST[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]10.45[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]44.46[/TD]
[TD] [/TD]
[TD="align: right"]54.91[/TD]
[/TR]
[TR]
[TD]UVWX[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]9.78[/TD]
[TD="align: right"]9.78[/TD]
[TD="align: right"]9.78[/TD]
[TD="align: right"]9.78[/TD]
[TD="align: right"]39.12[/TD]
[/TR]
[TR]
[TD]YZAA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]20.23[/TD]
[TD="align: right"]23.46[/TD]
[TD="align: right"]43.69[/TD]
[/TR]
</tbody>[/TABLE]



Is there a function/combination of functions that can be used to get this in Excel without using VBA? I am not very familiar with VBA yet to use it.
Thanks much for your help!
Vasishta.

 

[Special-K99]

Try (untested)

in L2
=SUMPRODUCT((MONTH(B1:K1)=MONTH(TODAY()))*(B2:K2))

 

[vasishta1729]

Thank you! But it did not work. It is giving the totals of data values of just that month. I am looking for the sum of values in "Total" column based on the month data starts appearing in the table. For all the part numbers the data starts appearing in January, I want the sum of values in "Total" column and similarly for all months.