Summary Page totals with filter

lrawhite

New Member
Joined
Nov 8, 2017
Messages
6
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!
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top