Difference between 2 cells

Question

If I select 2 cells in Excel, I cam see at the bottom the sum of the cells and the average. It would help when reconciling accounts if I could see the difference between the cells. I know I can enter =A1-A2 in an unused cell)

Answer 1

If I select 2 cells in Excel, I cam see at the bottom the sum of the cells and the average. It would help when reconciling accounts if I could see the difference between the cells. I know I can enter =A1-A2 in an unused cell)

Thank you folks. The suggestion from joeu2004 looks like the one for me.

Answer 2

Hello,

Rawmicheal,  

It is no possible, not only because Microsoft don't offer it but also because it is non logical requirement.

You can see in bottom several summarize functions, but they future is that they are independent on operands orders and counts. 

Only this kind of summarize function have sense.

Have u can calculate difference between 3 cells?

Answer 3

If I select 2 cells in Excel, I cam see at the bottom the sum of the cells and the average. It would help when reconciling accounts if I could see the difference between the cells.

The status bar only performs the functions that you can see when you right-click the status bar.  These are Excel functions.  There is no Excel function to perform the calculation that you describe.

A practical way to accomplish what you want is to enter =-A2 into some cell (e.g. B2).  Then select the cells that you want the status bar to sum; in my example, A1 and B2.  If the cells are not contiguous, use right-click to select the cells.

Then the status bar SUM function will show the difference.

Note that with this method, you are not limited to just two cells.  For your purposes, if you have a list of (positive) debits in A1:A10 and a list of (negative) debits in B1:B20, right-click to select A1:A10 and right-click to select B1:B20.  Again, the status bar SUM function shows the result of SUM(A1:A10, B1:B20).

Answer 4

Hi Michael

Excel status bar options only available for these options shown in the link:

https://support.office.com/en-us/article/excel-...

But you can use VBA scripting to show the differences

Sub Test()

a = Range("A1").Value

b = Range("A2").Value

c = a - b

Application.StatusBar = "The difference is " & c

End Sub

Now, put any number in cell A1 and any number in cell B1, and then see the status bar.