Hi Hope you can help me please.
I have attached spreadsheet in question.
I'm trying to create a formula which works out automatically how many accounts met SLA within 24 hours and how many went over 24 hours.
So i have manually inputted the results in column B and C:
0 = no issues
1 = issue
The issue needs to be resolved the following day, so if 0 appears following day, then i want a count to appear in within 24 hours column.
If there is another 1 the following day, it means it is over the 24 hours and i would like it added on to the over 24 hours column.
I just need a formula that will work out how many were resolved within 24 hours, and how many were over 24 hours. Hope this makes sense
Bookmarks