sum
 

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

sum
 

=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" wrote in message
...
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
--
Miche

sum
 

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


"Bob Phillips" wrote:

=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" wrote in message
...
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
--
Miche