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.