Link to home
Start Free TrialLog in
Avatar of kwhittemore

asked on

I have a complicated Excel 2010 workbook I'm building and I need help with the formulas

I am attaching the workbook. So basically, I have a drop-down menu in the Categories on sheet 1. what I need to do is in each of these categories take the Amount, total it and put it into sheet 2 in the corresponding matching classification of that category.

Each category should have it's own total showing up on sheet 2. The big deal is I don't know how to make that work.
Avatar of fabi2004
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kwhittemore


will that still work in a drop-down menu scenario?
I didn't notice you had a drop-down menu for the Categories column.  It looked like a filter.  Either way, it should work.  Try some sample data on a test workbook.
I think the sumif will work. Now i will have to get my cells correct.