Forum Discussion
Is there a formula for this?
I have a spreadsheet which shows the statuses in a partifular course (completed, not started, in progress) for a division which includes fifteen regions and over 1500 associates . I need to find the number of associates in each region who are in a particular "status" for the course. I know how to find out how many associates are in a specific region OR a specific status in the class using several differnt steps, but is there a formula which will take the number of associates in one region and count how many are in a specific "status" on the course and return that number?
Melissa, if you give a sample of how your data is structured (up to 10 rows) it'll be much easier to answer.
Division Region Store Progress The Do's and Dont's of Renewing Your Customer PV10 PV10 PV10 0.00 Not Started PV10 PR07 PR07 0.00 Not Started PV10 PR56 PR56 0.00 Not Started PV10 PR07 C0037 0.00 In Progress PV10 PR07 C0037 0.00 Not Started PV10 PR07 C0037 0.00 In Progress PV10 PR07 C0037 0.00 Not Started PV10 PR07 C0037 0.00 In Progress PV10 PR07 C0037 0.00 Not Started PV10 PR07 C0037 0.00 Not Started PV10 PR07 C0043 0.00 Not Started PV10 PR07 C0043 0.00 Not Started PV10 PR07 C0043 0.00 Not Started PV10 PR07 C0043 0.00 Not Started Melissa, sorry, still not sure i understood you correctly. If you mean associate = a record in your table; and status means Do's and Don't when something like attached. Shall Store and Progress are be taken into account?
