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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When found add it to the last and display total in Msgbox 23
Sum Function When Formula Produces #N/A 2
Looking formula that SUM values with specific value in neighboring colum 2
Code For Copy Copies Twice 3
Conditional Formatting with VBA 4
Macro for displaying formula 3
Convert A Formula to Value Until A Value is Met 1
formula works, functionworks, but not together 2

Back
Top