Sumproduct

[Legacy 386498]

Hi,

I have a file that I do a summary about different items (SKU) for a given entity for the current period (February in this case) and a YTD.

For the monthly one, the formula is a sumproduct based on the entity, SKU and period (201902). Is it possible to have one that's cumulative? For now I have a sumproduct for 201901+201902

I don't know if a sumproduct would be the best formula for that one. So the formula, based on the info at the bottom here, for 91301 - candy - YTD, I would have 206,01+25,01$. It's YTD so it's always from 20XX01 to 20XXcurrent period. The current period is in cell D3.

Thanks.



<style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #104E8B ; color: #FFF ; font-weight: bold; }</style>[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH][/TH]
[TH]201901[/TH]
[TH]201901[/TH]
[TH]201902[/TH]
[/TR]
</thead><tbody> [TR]
[TD]Entity[/TD]
[TD]Candy[/TD]
[TD]Chocolate[/TD]
[TD]Candy[/TD]
[/TR]
[TR]
[TD]91301[/TD]
[TD] 206.01 $ [/TD]
[TD] 15.38 $ [/TD]
[TD] 25.01 $ [/TD]
[/TR]
[TR]
[TD]91302[/TD]
[TD] 327.21 $ [/TD]
[TD] 16.86 $ [/TD]
[TD] 37.21 $ [/TD]
[/TR]
</tbody>[/TABLE]

 

[Legacy 386498]

Found it. I only needed to add a < before the period so it sums everything.