Excel Magic Trick 1405

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply