Running Balance does not match Total calculation

[Kat2016]

Good day,

I have a table that is calculating IN and OUT floats.

There are three types of floats these calculations are including.

K6 is my balance forward.

Column M is where my running balance is being calculated for each day.

My first formula is M7 =SUM(K6,J7,G7,D7,-K7,-H7,-E7) Where all the positives are IN floats and all the negatives are OUT floats.

The cell beneath that one is M8 =SUM(M7,J8,G8,D8,-K8,-H8,-E8)

This formula I use for the rest of the cells calculating the running balance.

At the bottom of each float I sum up each column. Exp. D39 =SUM(D7:D37)

I take those totals and I sum the INs from the OUTs. Exp. M39 =SUM(J39,G39,D39,-K39,-H39,-E39)

My problem is that the bottom of the running balance column M37 =SUM(M36+J37+G37+D37-K37-H37-E37)

does not match the totals that I summed M39 =SUM(J39,G39,D39,-K39,-H39,-E39)

I can't seem to figure out why these do not match. I hope I've given enough information to be able to visualize my predicament.

Any help would be greatly appreciated. I am fairly new to Excel and feel like I may be making an obvious mistake.

[mikeTRON]

Welcome to the forum.

Can you post a sample workbook with the data and the answer you ARE looking for?

[Kat2016]

The answer I am looking for is 1,500.00.

[Kat2016]

I should add that January with a balance forward of 0.00 all calculated perfectly. The problem begins in February.

[Kat2016]

I've come to realize that the problem is in cell K39. The =SUM(K6:K37) formula is not recognizing that cell K6 is negative.

Why would this occur?

[The_Snook]

Hi Kat2016,

It would be a lot easier to pinpoint the issue if you were to upload a sample workbook rather than a screenshot.

Regards,

Snook