Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking for a formula that would keep a running total of orders, based
on an account code. I tried using an "IF" function in B9 (=IF(A1=YT1731,A2,0)) but my first problem was I wasn't getting a numerical response back, only the typed out function. A B 1 T1731 $438.00 2 T1733 $637.00 3 T1732 $1,975.00 4 T1732 $75.00 5 T1731 $637.00 6 7 8 9 T1732 TOTAL 10 T1732 TOTAL 11 T1733 TOTAL What I want to do is build a nested? function which keeps a running total for each code (T1731, T1732, and T1733). What am I doing wrong?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
extract formula result form cell without running formula again | Excel Programming | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |