Excel Forum

Excel Magic Trick 442: Summarize Monthly Sales With Daily Transactional Dates - 5 Methods

Learn about Pivot Tables, SUMIF function, COUNTIF function and SUMPRODUCT function. Learn about:
1.How SUMIF and COUNTIF cannot handle arrays and so the solution means that we must add an extra column and use the MONTH, YEAR and TEXT functions.
2.PivotTables Pivot Tables are the fastest method
3.How to construct a SUMPRODUCT formula that requires two dates from only one date

Got a Question? Ask it Here in the Forum.