Sum all grouped items from each category

[Iboughtthefarm.ca]

I have data in column A (Barn, Garage, Water Damage, Yard) each is used in a drop down menu. Each row will have a category (column A) and a cost associated (Column E). I want a sum of each Categories full costs summarized in Column H. This could be described as a list of vendors and then a sum of all their associated bills.

See attached.


Jason

[Iboughtthefarm.ca]

Sorry file attached

[Pete_UK]

The file is still not attached - do it like this:

Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[Iboughtthefarm.ca]

Ok attached now

[Iboughtthefarm.ca]

thanks now I get it.

[Pete_UK]

Put this formula in cell H8:

=SUMIF(A:A,G8,E:E)

then copy down.

Hope this helps.

Pete

[popipipo]

I think the best way is a pivot table

[Iboughtthefarm.ca]

=SUMIF(A:A,G8,E:E)

This worked thank you

[Pete_UK]

Glad to hear it - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete