FORMULA HELP! (SUM between two cells)

larinda4 · Dec 16, 2022

I've been racking my brain trying to figure out a formula for this. I've included borders to help illustrate what I need.

I'm trying to sum column P based on the month in Q and subtract it from the debited amount in column S to get my monthly total in column T. I tried doing a SUMIF but as you'll see from the screenshot below, it won't calculate because there's a month for October and not November on the left and on the right, there's November and no October. Columns O and R are helper columns I created, but clearly it isn't working.

Generally there are more blank rows on the left hand side, but I figured this would make it easier. The start of the month on the left hand side will always be the same row on the right hand side. .

How can I sum this based on the month but also taking into account if the prior month is missing and adding it to the calculation?

DanteAmor · Dec 16, 2022

larinda4 said:
I'm trying to sum column P based on the month in Q and subtract it from the debited amount in column S

If you already have the date in column Q, check the following proposal. I am taking column R as a helper column to fill in the dates from column Q.
In column T are the totals using column R as a reference to calculate.

NOTE XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Example:

Dante Amor