SOLVED

Formula

Highlighted
ladyshar77
New Contributor

Hi All

 

I am trying to create a formula in order to show it on a pie chart but need help.  Below are my response time.  I need to show anything that is 0 Hours and 0 Mins as within the SLA and anything over 0 hours and 0 mins as outside of SLA.

Within I used the formula of =COUNTIFS(M1:M32,"=0", O1:O32,"=0") which gave me my figure but I can't do the outside of SLA. It keeps bringing the answer of 2 and not 3.

Much appreciated

 

SLA Response Time 
0hrs0mins
0hrs0mins
0hrs0mins
0hrs0mins
0hrs0mins
0hrs0mins
0hrs0mins
0hrs0mins
1hrs30mins
0hrs0mins
4hrs22mins
0hrs33mins
4 Replies

Hi,

 

That could be

=SUMPRODUCT(--((M1:M32+O1:O32)>0))

thanks for the quick reply, tried that it's coming up with an error of #Value

Solution

Please check in cell R1 attached

Great it works, thank you for your help

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies