Excel Magic Trick 1405

Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records


See how to calculate Monthly Totals for Sales from Daily Records and Ad Costs from Month Records using SUMIFS and EOMONTH functions. This Granularity mismatch between Month and Day is easy to deal with by using Excel Formulas.
(00:10) Introduction.
(00:50) Sales Monthly Totals using SUMIFS and EOMONTH functions.
(04:25) Ad Cost Monthly Totals using SUMIFS.
(05:12) Summary.


Download “Excel Magic Trick 1401-1405” Excel-Magic-Trick-1401-1405.zip – Downloaded 128 times – 1 MB

Be the first to comment

Leave a Reply