Filter results on a different worksheet.

OK - I'm going to try to be clear on what I'm trying to figure out here

I have a worksheet (WS2) that has a number of lists in columns with corresponding results. For example, Columns A - D have drop down lists (year, community, status, month), and columns E-H have corresponding values (target revenue, online revenue, offline revenue, total revenue).

In another worksheet I would like to have a summary page. 4 cells have drop down lists that correspond to Columns A-D in WS2, and I would like to have 4 cells that display the summed results of Columns E-H in WS2, depending on the selections from the drop down lists. I know this can also be done using filters in WS2, but a summary page like this could be more user friendly for those who are not familiar with Excel.

Do I use filters for this somehow, or do I build some complex functions? Any suggestions?

Originally Posted by TMShucks

I'm having difficulty visualising the requirement. Can you post a sample workbook?

Regards

Here's an attached sample workbook.

In the summary worksheet, I would like the listed results

Stated Goal Amount:
Online Amount Received:
Offline Amount Received:
Total Amount Received:


to show, based on the selected criteria at the top, using the data in the Events worksheet.

To me it seems like an autofilter-like function, where the criteria is selected in the summary page, and resulting sums are made from the list in the Events Sheet, which are then displayed on the Summary sheet.

I hope that makes sense.

Thanks!

Originally Posted by TMShucks

Use a Pivot Table. See the attached example.

Regards

Awesome! Thanks!