Hello:
Please refer to attached file.
I have month data as shown in monthly sheet.
I need to summarize the data in Summary Sheet depending on value in cell A1.
In this example A1 is Mar.
So i need formula in highlighted cell to add value from each month until month shown in cell A1.
In this example, i would need to add Jan,Feb and Mar values.
I have manually added in SUmmary Sheet, cell B3 as shown.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks