M
MikePearl
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)
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)