Summary Page totals with filter

[lrawhite]

I have several sheets of information that I would like to be totaled on a Summary sheet. I would like the Summary sheet to show the filtered data from Sheet 1, Sheet 2, Sheet 3, etc. The information listed in Sheet 1, Sheet 2, Sheet 3, etc. contains multiple rows with the same cell value, however, the column for the information may change for each piece of data.

I have used an extremely long and complicated formula that works well, however, when I filter the data in Sheet 1, Sheet 2, Sheet 3, etc., it gives me the sum of all the data and not the filtered data.

I have a sample workbook, however my posting permissions state that I am unable to post attachments.

Can you please help????

Thank you!

 

[sheetspread]

my posting permissions state that I am unable to post attachments.

No one can post attachments, that "permissions" status is misleading. You can save to a file hosting service like google or dropbox and post the link here.

Have you tried Excel's data consolidation feature?

 

[lrawhite]

I have not. I am not a novice, but definitely not an expert at excel. I will try dropbox. Hopefully this works.


https://www.dropbox.com/s/f6fvqkq728rsdap/sample workbook.xlsx?dl=0

 

[lrawhite]

I did try the consolidation function, however, it does not work on filtered data. I need Sheets 1, 2, and 3 to be filtered and sum the filtered data.

 

[sheetspread]

Do you have Power Query (BI Tools)? You can append, filter, and total.