Hello!
I wonder if someone can help me?
I have a work book with a summary sheet and also several data sheets.
In each data sheet I have a cell (A1) with a value in it. In B1 there is a date.
I need to find a way to get a total in the summary sheet of the total of A1's in all sheets if the corrisponding date in B1 is within a year of todays date.
E.G. If I have 10 sheets and 6 of them have dates that fall within a year, I need the total of the value for those 6 sheets.
Is there a way of doing this?
I wonder if someone can help me?
I have a work book with a summary sheet and also several data sheets.
In each data sheet I have a cell (A1) with a value in it. In B1 there is a date.
I need to find a way to get a total in the summary sheet of the total of A1's in all sheets if the corrisponding date in B1 is within a year of todays date.
E.G. If I have 10 sheets and 6 of them have dates that fall within a year, I need the total of the value for those 6 sheets.
Is there a way of doing this?