Hi.
I would like to know, if I had a cell that had a name defined to it, so "SavingsMoney"
Is there a formula I can use, that will find any cells within a range that is using "SavingsMoney" e.g. "=SUM(SavingsMoney)", and then add all of them together, so say if savings money was set to £50 and I put the =SUM formula in 3 boxes, I'd want the specific box that adds all of them up to show £150.
Thanks.
I would like to know, if I had a cell that had a name defined to it, so "SavingsMoney"
Is there a formula I can use, that will find any cells within a range that is using "SavingsMoney" e.g. "=SUM(SavingsMoney)", and then add all of them together, so say if savings money was set to £50 and I put the =SUM formula in 3 boxes, I'd want the specific box that adds all of them up to show £150.
Thanks.