Adding formula to accommodate drop down

[creative999]

I have a summary sheet which has several different formulas. The actual data is spread across multiple worksheets.
I need the selectable drop down (ie abc, xyx, ALL) on the summary sheet to work for each formula. These formulas are a sumif, countif, unique count, average. Each data worksheet has a common column name called Customer but is in a different column location in each sheet.

Amy suggestions?

 

[creative999]

Forgot to add:

‘Each data worksheet has a common column name called Customer’

This is the selectable drop down list.

 

[jasonb75]

Does the dropdown refer to a sheet, or items within the 'Customer' column of a sheet? If you need the formula to look at items within the customer column on every sheet and aggregate the results to a single total in the summary sheet then it could get very messy.

It may be necessary to clean things up by collating the data into a table on the summary sheet before attempting to do anything with it.

 

[creative999]

Does the dropdown refer to a sheet, or items within the 'Customer' column of a sheet? If you need the formula to look at items within the customer column on every sheet and aggregate the results to a single total in the summary sheet then it could get very messy.

It may be necessary to clean things up by collating the data into a table on the summary sheet before attempting to do anything with it.

Formulas need to look at items within each sheet / customer columns and aggregate the results in the summary sheet.
Am I righting in thinking every formula on the summary will need to be adjusted to cater for the drop down list, ie adding a IF at the start. Will be very messy

 

[jasonb75]

Formulas need to look at items within each sheet / customer columns and aggregate the results in the summary sheet.

So as an example, if you had say Sheet1 and Sheet2 with a customer column on each, and a criteria of "xyz" in the dropdown then the countif formula would need to return the count of "xyz" on both sheets?

How many sheets do you have with "Customer" columns on them? Are more going to be added later?

 

[jasonb75]

Additionally, you only mentioned the customer column in the sheets, but some of the formulas would be looking at more than 1 column so we would need all of the information, not just part of it. Are all columns that the formulas refer to going to be in different positions on each sheet?

 

[creative999]

Ea

Additionally, you only mentioned the customer column in the sheets, but some of the formulas would be looking at more than 1 column so we would need all of the information, not just part of it. Are all columns that the formulas refer to going to be in different positions on each sheet?

Each worksheet has a different data set. Some has amounts, some have dates, etc. the summary sheet which has the formulas summarises each of these. But the drop down needs to recalculate based on customer which is available across all the sheets. Hope that makes sense.

 

[jasonb75]

Hope that makes sense

Nope.

As an example, you said that you have a SUMIF formula. That will require a criteria range (customer) and a range to sum in every sheet. We would need to know how the sum range relates to the customer column, is it the same for each sheet? If not then you have a greater chance of shooting the moon with a water pistol than finding a solution.

To be honest, each reply from you is making it look more impossible than the last. Without a visual example of a couple of sheets and the expected summary I'm not even going to think about attempting anything.