Thread: Formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
STRAC STRAC is offline
external usenet poster
 
Posts: 13
Default Formula?

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??