| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
