Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cumulative Total with a twist
I am useing Office XP I use this formula =IF(CELL("address")="$A$4",A4+B4,B4) Is there a way to get it to subtract in this way Recived total used total on hand 100 100 50 50 I know that there is no record of recived that works for me. Can I get it to work in the same way subtracting used giving a total on hand until I reach a total of 0 on hand. This is for my own work shop inventory. -- zipper21 ------------------------------------------------------------------------ zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025 View this thread: http://www.excelforum.com/showthread...hreadid=529120 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cumulative total | New Users to Excel | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
cumulative total | Excel Worksheet Functions | |||
CUMULATIVE TOTAL | Excel Worksheet Functions | |||
Cumulative Total | Excel Discussion (Misc queries) |