Forum Discussion
Sum Date range by criteria
I need to find the value of a date range by criteria that may repeat in the row. This is just a simple idea of what I might need. I at times have 4 to 10 different categories. Jan Feb ...
=SUMPRODUCT(($B$2:$B$10=A13)*OFFSET($C$2:$C$10,0,0,9,MATCH($B$12,$C$1:$J$1,0)))For the sum from january to any end month you can try this formula. Enter the end month in cell B12 in this example.