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!
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!