Adding up associated cells...probably easy

[clacka]

I have an expense report that I am trying to automate... and I have a small problem. It looks big from the size of this post, but it really isn't:

Multiple entries on the expense report may come from the same receipt but must be posted to different accounts. For example, someone may go to the store and buy a pound of coffee and a ream of paper. The items will be on the same receipt but will need to be posted to different accounts (e.g., Food Expense and Office Supplies Expense).

So I have 9 columns:
A. receipt number (they manually number the receipt with a pen),
B. entry number (generated automatically in sequence 1,2,3...),
C. Vendor/store,
D. Brief Description,
E. $Amount of item,
F. Sales tax local,
G. Sales tax federal (both taxes calculate automatically, no problem),
H. Total (E+F+G),
I. Account to be charged (this is populated by a drop down list, no problem)

Here is my question:
I want excel to automatically audit. That is, I would like excel to look at all of the items that come from receipt number x, add all of the column H numbers associated with that receipt number and put the total in a row immediately under the last item associated with that receipt number. That way the manager making the entry can check to be sure that the total printed on the receipt is the same total that excel comes up with.

[dominicb]

Good afternoon.

Hopefully this should do exactly what you want.

=SUMIF(A:A,36244,H:H)

This formula will look in column A for a receipt number 36244 and where it finds it, add up the corresponding figures in column H. That is to audit any single given receipt number.

If you wanted to fo this to every single receipt, it would be easier to use the Data > Subtotals... facility. This would summarise the whole list by receipt number.

Hope this is of some use to you.

[Montrose77]

Better yet, try this:

=SUMIF(A:A,A2,H:H)

Assuming the formula is in cell J2.

That way the formula can be filled down the whole of column J, and will automatically display the total amounts for the receipt listed.

[clacka]

WORKED LIKE A CHARM!

Thanks folks!
Alan