Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm trying to automate a method of summing across columns. To be exact, let's say I have 5 columns (A B C D E), the first of which MIGHT contain a negative value (it may also contain a positive value, and B C D E might have a zero or some positive value. What I want to do is... IF A has a negative value I want it to add it to E (to reduce it), if E becomes zero and there is still some left from A, I want it to add the remainder to D... then C.... then B. Essentially I want the values of E D C B to be reduced, in turn, by the value that is in A (but only if A has a negative value). I'm hoping this makes sense... and I'm hoping someone out there can figure this out. Cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hOW DO i SUBTRACT COLUMNS IN EXCEL? | Excel Discussion (Misc queries) | |||
How do I subtract two columns from the same total? | Excel Discussion (Misc queries) | |||
subtract amounts from different columns? | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
macro to subtract columns and put result in new column | Excel Programming |