Formula COUNTIFS, criteria in multiple columns and MTD
I have a sheet that lists every call for service that shows the Date, Crew1, Crew2, if it was a transport, and if it wasn't, the reason for not transporting. I'm trying to get a formula to work that counts the total calls that a crew member ran in the current month and how many of those calls did they transport. I can't get anything to work.
Total Calls - Only count Cancel Reason <NONE> and Patient Refused Transport
Total Transports - Only count Cancel Reason <NONE>
The Director wants non-transport percentage for each crew member for the current month as well as yesterday. The top picture is all the data. The second picture is what I need but I need it just for the current month and yesterday.
*I do have another helper column that is a checkbox if it is the current month if that is easier.
Help Article Resources
Check out the Formula Handbook template!