Formula?

  • Thread starter Thread starter STRAC
  • Start date Start date
S

STRAC

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
 
Back
Top