ChatterBank0 min ago
Excel Formula
Calling all Excel wizards! I have a chart which I use for managing my finances. In Column B, I have all my outgoings separated into Categories (House, Car etc.) and in Column C, Every month when the payment gets taken by direct debit, I enter the date the direct debit has gone out of my account.
What I want to do is create a formula which adds the values in Column B but only once a date has been entered into the adjacent cell in Column C, I'm guessing it's going to be a SUMIF formula but even with a lot of googling, can't seem to figure it out. There will always be values in Column B as they are set amounts which get taken each month however until the payment has been taken, the corresponding cells in the date column (C) will be blank, however I still want the formula to add the values against cells which corresponding dates have been inputted. I hope that makes sense, please can anyone help. TIA
What I want to do is create a formula which adds the values in Column B but only once a date has been entered into the adjacent cell in Column C, I'm guessing it's going to be a SUMIF formula but even with a lot of googling, can't seem to figure it out. There will always be values in Column B as they are set amounts which get taken each month however until the payment has been taken, the corresponding cells in the date column (C) will be blank, however I still want the formula to add the values against cells which corresponding dates have been inputted. I hope that makes sense, please can anyone help. TIA
Answers
Best Answer
No best answer has yet been selected by benny3008. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
-- answer removed --
-- answer removed --
Brill thanks, that's put me in right direction, only thing is, using that formula, it does opposite to what I need, its added all the cells which are next to empty cells. any ideas please? Also, as the values in my chart are not all in order e.g. there are values in A1:A6 and then values in A10:A15, how would i get around that please.
-- answer removed --
-- answer removed --