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...
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?
Sergei - each line represents one associate. I need to get a count of how many associates in say PR07 (Region column) have the status of "Not Started" (The Do's and Don'ts ... column).
Does that make sense?
