Donate SIGN UP

Excel Formula

Avatar Image
benny3008 | 15:59 Mon 05th Jun 2017 | Computers
7 Answers
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
Gravatar

Answers

1 to 7 of 7rss feed

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 --
Question Author
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.
Question Author
ah, you have answered my first question while i was replying, cheers
-- answer removed --
-- answer removed --
Question Author
Excellent thank you

1 to 7 of 7rss feed

Do you know the answer?

Excel Formula

Answer Question >>