I thought that SUMIF would work...

The SUMIF that you are using matches a range against a single value.
For instance, if you were looking for the sum of all items where Col A = 20, the you would use:
=SUMIF(A1:A5,"=20",C1:C5)

BUT: You want to calculate the sum for items where Col A items match Col B items. Since, you are comparing 2 ranges, so you need an array formula like this one:
=SUM(($A$1:$A$5=$B$1:$B$5)*$C$1:$C$5)
(Note: Commit that array formula by pressing [Ctrl]+[Shift]+[Enter])

Does that help?

Regards,
Ron

That code only seems to be working within a given line, that is if A1=B1 then add C1, almost like a true/false result. If I plug that formula into column D, thjisis the result I'm getting:

--A---B---C--D
1 10 30 $5 0
2 20 30 $10 0
3 30 30 $5 $5
4 40 10 $10 0
5 50 20 $10 0

How do I get D# to return "$20" (i.e. C1+C2+C3)?

OK...I think I'm FINALLY on the right track here.

Try running this formula down col D:

=IF(A1=B1,SUM(C$1:C1),0)
Just press Enter for this one.

Note though, it always sum from the C1 down to the row where A=B. Is that what you want?

Regards,
Ron

Let me put it a different way - Column A is an account number. Columns B and C indicate charges toward the accounts in column A. So, every time I enter an account number from A in B, I want it to keep a running subtotal. Therefore, I charged "Account 30" three times in column B, twice for $5 and once for $10. I actually want to create a column that will give me a running total of charges next to each account number in column A. Does that make sense? Sorry, I'm hving trouble verbalizing it!

BTW, after hitting ctrl, shift before hitting enter (giving me the brackets), in my example I'm getting:

--A---B---C--D
1 10 30 $5 $5
2 20 30 $10 $5
3 30 30 $5 $5
4 40 10 $10 $5
5 50 20 $10 $5

When I want to get:

--A---B---C--D
1 10 30 $5 $5
2 20 30 $10 $0
3 30 30 $5 $20
4 40 10 $10 $5
5 50 20 $10 $0

(Accounts 10 and 40 were charged $5 each, and Account 30 was charged $20. Accounts 20 and 50 weren't chrged anything - they don't appear in column B)

OK...I think I'm FINALLY on the right track here.

Try running this formula down col D:

=IF(A1=B1,SUM(C$1:C1),0)
Just press Enter for this one.

Note though, it always sum from the C1 down to the row where A=B. Is that what you want?

Almost! that gives me the result that I want for line 3, but I want it to say whenever there's a match in line B for A, add C...

The amounts in column D puzzle me.

Here's what I'm thinking.
--A---B---C--D
1 10 30 $5 $5.......Acct10 has a $10 entry in C4, so D1=$10
2 20 30 $10 $0.....Acct20 has a $10 entry in C5, so D2=$10
3 30 30 $5 $20.....Acct30 has 3 entries (C1:C3 for $5, $10, $5) D3=$20
4 40 10 $10 $5.....Acct40 is not ref'd in Col B, so no activity. D4=$0
5 50 20 $10 $0.....Acct50 is not ref'd in Col B, so no activity.D5=$0

Try wording your logic like that and let's see if we can solve this.

Of course, if the desired solution is just obvious for any other members, please jump in and please share.

Regards,
Ron

--A---B---C--D
1 10 30 $5 $5.......Acct10 has a $10 entry in C4, so D1=$10
2 20 30 $10 $0.....Acct20 has a $10 entry in C5, so D2=$10
3 30 30 $5 $20.....Acct30 has 3 entries (C1:C3 for $5, $10, $5) D3=$20
4 40 10 $10 $5.....Acct40 is not ref'd in Col B, so no activity. D4=$0
5 50 20 $10 $0.....Acct50 is not ref'd in Col B, so no activity.D5=$0

That's it - exactly. Ignore what I said in my previous post - I was way off (and misleading - sorry). You've got the logic - can I make that work?

YeeeeeHAAAAA!

OK....enter this formula in Cell D1 and copy it down to D5
=SUMIF($B$1:$B$5,A1,$C$1)

Regards,
Ron

YOU GOT IT!

Thanks a million!

There's no need to enter the entire range to be conditionally summed.The SUMIF function automatically expands that range so it matches the number of rows in the test range.

Consequently, =SUMIF($A$1:$A$100,"=10",$B$1) will implicitly behave as if you entered =SUMIF(A1:A100,"=10",$B$1:$B$100).

Thanks for your concern.

Regards,
Ron