sum by account number

[drecollet]

I have my petty cash sheet and I expense it by account number. I buy newspapers daily and I buy widgets weekly. Therefore on my petty cash sheet for the month, I want to make it so that it give me a total by account number.

How can I do this?

[Oscar]

sumif(column with account number, "Account Number", column with amounts)

[VBA Noob]

Look in excel help for sumif

For example

=Sumif(A:A,"Account 1",B:B)

Where Col A has accounts and Col B as values

VBA Noob