Help With My Checkbook

[Justinian]

I want to write a formula so that all expenses for January get summed in a cell below my checkbook labeled "January." I need a formula that sees if the word January is entered into a cell and if January is entered, no matter in how many cells, the formula adds those expenses into my total cell below which is also named January. The same applied for February and all months of the year. How do I do this?

 

[erik.van.geit]

Your last reply sounds rude. You could have just said it was formatting.
It sounds bad because the focus lays on giving a lesson, but doesn't talk about the formula you recieved.

Your example had dollar signs isn't it? So you were not sure why I assumed that?
You told that SUM.IF didn't work. Since SUM.IF DOES work - just following the helpfiles anyone can find out that it does - I was trying to figure out the reason why it wouldn't work for you. That's the main reason to assume that the $ signs were the problem.
I hope that you will see that.

You also stated that a PIVOT table wouldn't work. I'm sure it does too. RoyUK pulled back after that statement (he gave you a second chance after you misunderstood his 1ste reply): that was very clever to my sense, it could have been better for me if I followed him.

So I think we are not made for each other.
Farewell!

 

[royUK]

You aren't helping yourself with your replies to any suggestions.

You have already been asked to provide an example workbook so use something like DropBox.