Help with Subtotal formula



I have seen this formula work before, where all I did was copy and paste.  I didn't keep a copy of it and am not able to find it to replicate.

I am looking for a formula that will subtotal in a seperate column using "At each change" data from another column, and totaling from a Debit column less a Credit column.

There can be multipul rows containing the same SO# due to multipul line items.  I had seen that when there are multipul rows, that only the last row containing the same SO# would physically show the balance, whereas the other rows with the same SO# would be whited out, but the formula would show in the formula line.

If you can help me, I would appreciate it very much. 

I've shown a screen shot below for an example;

Debit                 Credit            So#            Total

0.00                   53,130.00     37806                       - Total cell will contain formula but be whited out

0.00                     1,820.00     37806           $$$      - This cell will contain formula but be visable, showing the grand total of the SO#

4,102.60                       .00      38146          $$$      - This cell will contain the formul be be visable, showing the grand total of the SO#



Honestly, I'm not getting this. Can you edit your question and upload a sample file?
don (rep: 1247) Nov 1, '16 at 7:56 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login