|
|
Featured Tutorial
Featured Macro
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
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