Excel formula change
Budget: $10 – $30 AUD
=IF(ISBLANK(I4),"",SUMIF($A:$C,I4&"*",$C:$C))
Need the value in E4 & E7. At the moment it is taking the value from E5 & E8. When it see the Credit 1234 or Credit 4567, I don't want the value next to it. I want the value next to it and up one.
Only change the cell in red
No wholesale changes to the formula and follow the same formula vibe. I have cut down the spreadsheet to simplify my question so please don't go changing it overall function that is not apparent in this cut down version.
Thank you for taking a look at this.
Thank you
Need the value in E4 & E7. At the moment it is taking the value from E5 & E8. When it see the Credit 1234 or Credit 4567, I don't want the value next to it. I want the value next to it and up one.
Only change the cell in red
No wholesale changes to the formula and follow the same formula vibe. I have cut down the spreadsheet to simplify my question so please don't go changing it overall function that is not apparent in this cut down version.
Thank you for taking a look at this.
Thank you