Hi all,

I have an issue, where I have a formula to capture a month and its data.
The month on the columns keeps changing, example A1=Jan and the follwong
month A1=Feb... so on and so forth

I need to have the data of Jan and Feb captured.

My problem is, when the month changes, the previous month data dissapears.

Can anyone help?

My formula that I used:
=IF(ISNUMBER(SEARCH("FEB",FinalRevised.Parent!$AH$ 2)),SUMIF(FinalRevised.Parent!$E$1:$E$100,"=14000" ,FinalRevised.Parent!$AH$1:$AH$100),0)