STRAC wrote:
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??


Your first problem is likely that the cell(s) where you are entering the
formula are formatted as text. To fix that first format the cell(s) as
general (or dollars).

Then place this formula in B9 and fill down:
=SUMIF($A$1:$A$5,A9,$B$1:$B$5)