Link Status Bar sum amount to a cell

Hello All,

I was wondering if there is a way to link the sum that is shown in the status bar when you highlight multiple cells to a specific cell, or if highlighting cells can be summed in a given cell.

Basically, I have long spreadsheets relating to invoices, sometimes with numerous values on them, and want to be able to quickly tie certain amounts to the totals I should have.

Here's a brief example of what I am looking at. Below are my totals

(163,044.71)
24,425.37
82,764.39
53,451.85
2,403.10

And here's a snip of my data set

542.73
8.03
5,111.58
5,111.58
15.00
15.00
(15.00)
(5,111.58)
114.30
262.01
446.64
23.13
262.01
446.64
23.13
446.64
23.13
446.64
23.13
85.86
45.88
2,016.11
1.98
3,176.69
900.00
0.30
1,330.77
49.51

The items highlighted in red tie to the last balance in the total sheet, 2,403.10. And this one was easy for me to find because it was all from the same vendor. It becomes tricky when the totals go across multiple vendors or items. So what I want to do is have a cell referenced to sum up the cells I currently have highlighted, and use a total cell where I input the total I need, and I can use this cell minus the cell that is summing all the cells I highlighted to quickly show me how much my totals are off.

So my cells would look like this A1 = 2403.10, B1 = Status Bar Link, C1 = A1-B1

Currently what I do is just use the calculator and subtract the total in the status bar from the total I'm looking for, but it would be much easier to just unclick and re-highlight areas until I find the totals that agree to the balances I have.

This probably can't be done, but this group here has helped me figure out so many short cuts, I figured I would ask. Google has been no help in my search. And if this can't be done, someone should make it happen

Thanks in advance

Thanks for that, can you explain what I do with this code now? I have a bunch of Macros I use, do I just add it to that list?

I see, thanks for the help. That is a pretty awesome tool.

Hi, I just realized there is one issue with this code. I need it to be able to sum up all of the items I need which may not be in adjacent cells. ie I hit CTRL and highlight cells I need, release the mouse and click other cells and the second group of cells do not show up in the sum.

Thoughts?

Thanks in advance

Can anyone else chime in on this? I need my total to show all highlighted items, as the sum in the status bar would if I clicked multiple amounts throughout a sheet.

Thanks