Excel: Count a Dropdown value from one worksheet and past the Count of the number of those status' on another Worksheet
I have a spreadsheet that consists of five worksheets, each with their own individual name. Each of these worksheets has a "Status" column on them which consists of several status' values in it's filter drop-down, e.g. "not managed", "ping failed", "shutdown" and so on... What I'd like to do is provide a count of the status (depending on which status you choose) on another worksheet within that same workbook which is named "Legend". What would be the best formula for attempting this?
test.xlsx
test.xlsx
ASKER
If you are on worksheet 1, and under the status column you select "ping" and filter off that and let's say that provides all systems that have been pinged. I'd like to take that overall count and push it's value to another worksheet labeled "legend" which consists of ALL status' and provides a brief explanation of each, then to the side of that explanation is the count of that status based off of the other worksheet values. hope that makes better sense.
So will you have a count for all worksheets and all statuses on the Legend sheet or do you want to be able to change the worksheet and the status on the legend sheet so that you can see the result.
See attached, still guessing at what you need as still not clear.
test--4-.xlsx
test--4-.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, Rob.
Maybe a file which is more representative of the real thing would be better.