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...
| 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?
When it likes in my file attached to previous message - you may use COUNTIF; or PivotTable, and not only. Depends on how you'd like to represent your figures
Thank you so much for you help, it worked!!