Finding the Difference Starting with Zero Dollars

The_Game

New Member
Joined
Mar 27, 2015
Messages
31
I'm trying to find the difference of two arrays and have it tell me the difference starting with zero and counting up. I've got two columns, Sub Total (estimated cost) and the Actual total (cost at the time of sale). The Actual hasn't been set up because we haven't purchased anything yet, hence the example. Because these values can change once items are purchase, I want to track if parts cost more or less and show me a total difference that sum up from zero, instead of counting them down from $74K. This way I can reference how much I've got to scrape off the top to allocate elsewhere as items are purchased. Is there a way to calculate the difference from zero and work my way up to $70K (assuming everything I purchase is worth $1)?

Tables aren't working on this computer, so bear with me.


Subtotal Example Actual Total Actual Total Difference
$100.12 $112.13 ... -12.01
$1122.30 $1000.00 ... +122.30
... ...
... ...
Totaling: $74,135.11 Total Difference: +110.29
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,216,458
Messages
6,130,754
Members
449,588
Latest member
accountant606

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top