Excel Formula

[benny3008]

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

[benny3008]

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.

[benny3008]

ah, you have answered my first question while i was replying, cheers

[benny3008]

Excellent thank you