Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records



Download File: http://people.highline.edu/mgirvin/excelisfun.htm
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.
1. (00:10) Introduction.
2. (00:50) Sales Monthly Totals using SUMIFS and EOMONTH functions.
3. (04:25) Ad Cost Monthly Totals using SUMIFS.
4. (05:12) Summary.

Granularity mismatch between Month and Day.
Monthly Sales & Cost Report: Sales from Daily Records, Costs from Monthly Records

source