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

If you don't have too many variables you want to sum you can use the function
SUMIF. If your trying to sum thousands of items this would be too cumbersome.


in cell 9B enter formula =SUMIF(A1:A5,"=t1731",B1:B5)
in cell 10B enter formula =SUMIF(A1:A5,"=t1732",B1:B5)
in cell 11B enter formula =SUMIF(A1:A5,"=t1733",B1:B5)

Mark


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

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)