Forum Discussion
ladyshar77
Jan 02, 2019Copper Contributor
Formula
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 | |||
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 0 | hrs | 0 | mins |
| 1 | hrs | 30 | mins |
| 0 | hrs | 0 | mins |
| 4 | hrs | 22 | mins |
| 0 | hrs | 33 | mins |
Please check in cell R1 attached
4 Replies
- SergeiBaklanDiamond Contributor
Hi,
That could be
=SUMPRODUCT(--((M1:M32+O1:O32)>0))
- ladyshar77Copper Contributor
thanks for the quick reply, tried that it's coming up with an error of #Value
- SergeiBaklanDiamond Contributor