Sumproduct

L

Legacy 386498

Guest
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>
201901201901201902
EntityCandyChocolateCandy
91301 206.01 $ 15.38 $ 25.01 $
91302 327.21 $ 16.86 $ 37.21 $

<thead>
</thead><tbody>
</tbody>
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Found it. I only needed to add a < before the period so it sums everything.
 
Upvote 0

Forum statistics

Threads
1,207,442
Messages
6,078,582
Members
446,350
Latest member
FrancieRech

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top