A formula that can be used in whole column that brings back a positive result.

Hi,

I have a formula (=IF(I28=I29,0,-V29) in column AE. I also have the formula (=SUMIF(H28:H28,"I - Shop Order Component Issue",T28) in column AF. I have the formula (=-(AF28-AE28)) in column AM.

Now, column "I" in the formula in column AE is a part # which results in the same # in column AE. I only need the value in AE to show up once for the multiple of rows for that same part #, hence my formula. Now in column AF, the values for the same part # are different ( hence why I cannot use the same formula as in AE).

Now, I have the formula in column AM to essentially calculate the difference between all rows with the same part #. This formula (=-(AF28-AE28)) only works when the sum in range AF28:AF33 is more than the value in column AE of the same part #. When the sum in range AF28:AF33 is less than the value in column AE, it brings out a negative value in column AM( the value is the correct value, I just cannot have it negative).

I have tried a multitude of things ranging from using ABS(), IF(), OR(),AND(),SUMIF(), along with other formulas. I just can't seem to figure out how to work the formula to read a positive sum in column AM.. Please help!!

=IF(I28=I28,0,-V29) wont that always be 0?

i think its time for you to upload a workbook showing the expected results
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

here it is - the columns have changed. if you select columns' X,Y,Z you can see the formulas and follow them to the correct columns.. Thanks

i realy dont follow the logic why do some numbers stay -ve and others change?

I don't understand much of what you are trying to do and your special formatting but it sounds like you need to use the ABS function somewhere.