writinglife
New Member
- Joined
- Sep 9, 2014
- Messages
- 4
I've skimmed the forum and can't find a close resemblance to my issue. If I've missed somethig, please let me know.
I have to provide a report of how many service calls were logged by type. A report that is automatically produced provides me with 1 column that shows the source (phone/email). In my report (an excel spreadsheet that takes information from the raw data provided and has the names of the employees listed already. What I need to to is take the phone/email data and report how many phone calls and emails that person A-Z took.
At the moment, I just use a Count function to tell me how many times the name appears in the "logged" column, but this needs to change to report how many times this person appeared in the logged column when the source column read "phone" or "email".
I probably haven't explained it well, but I hope someone here can help.
I have to provide a report of how many service calls were logged by type. A report that is automatically produced provides me with 1 column that shows the source (phone/email). In my report (an excel spreadsheet that takes information from the raw data provided and has the names of the employees listed already. What I need to to is take the phone/email data and report how many phone calls and emails that person A-Z took.
At the moment, I just use a Count function to tell me how many times the name appears in the "logged" column, but this needs to change to report how many times this person appeared in the logged column when the source column read "phone" or "email".
I probably haven't explained it well, but I hope someone here can help.