Hello,
I am currently working on a project and I am in need of excel assistance. I have a sheet that has a lot of client data (e.g. name, date of assistance, reasons for seeking help). In another sheet, I am gathering data with regards to all clients. For instance, I want to know how many clients in the month of January came to our office to seek assistance for, say, wifi connection problems, app problems, etc. I was able to use sum and countifs to find how many clients overall have come to our office to seek assistance for wifi connection problems, app problems, etc. However, I want to be able to narrow down the number of clients seeking help with the different reasons listed above in a given date range (e.g. 1/1/17-1/31/17).
If any one has an answer or advice, please let me know.
Thank you!
I am currently working on a project and I am in need of excel assistance. I have a sheet that has a lot of client data (e.g. name, date of assistance, reasons for seeking help). In another sheet, I am gathering data with regards to all clients. For instance, I want to know how many clients in the month of January came to our office to seek assistance for, say, wifi connection problems, app problems, etc. I was able to use sum and countifs to find how many clients overall have come to our office to seek assistance for wifi connection problems, app problems, etc. However, I want to be able to narrow down the number of clients seeking help with the different reasons listed above in a given date range (e.g. 1/1/17-1/31/17).
If any one has an answer or advice, please let me know.
Thank you!
