Excel Forum



Excel Magic Trick 611: Array Formula Year Over Year Sales Calculation From Daily Transactional Data


Create an Array Formula to summarize sales for Year Over Year Sales using the SUMPRODUCT and YEAR functions. Calculate a formula for Percentage Change.





Got a Question? Ask it Here in the Forum.