creative999
Board Regular
- Joined
- Jul 7, 2021
- Messages
- 85
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
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?
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?