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.