sum

[Miche]

I am doing an expense form. I will enter manually the account codes from
column A in column C. I am looking for a formula that will get the total of
each account.
A B C D
ACCT NO EXPENSE ACCT NO TOTALS
6500 13.99 6500 ???
6210 45.00 6210 ???
6370 47.50 6370 ???
6500 60.00 6210 ???
6500 60.00
6370 32.50
6370 19.99
6210 25.00


Any help would be appreciated

 

[Bob Phillips]

=SUMIF(A:A,C2,B:B)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Miche]

Thanks so much ... it worked!
--
Miche

=SUMIF(A:A,C2,B:B)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)