Best way of Counting a given number of States
I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot.
The only way I could think of for now was to get the data by cell linking and doing some calculations on it in an extra sheet. As it turns out now, doing all of this "manually" for multiple sheets and multiple states is quite a lot of work.
Is there any other, more "comfortable" way of doing this?