Hi,

I'm sure the solution to this is pretty simple, but I can't work out whether the issue is because the sum is time or the formula's I am trying. I want the table to the right to sum the times that fit the criteria on both axis, so for example all the times for "Andrew W" in the state "Alerting" to sum and show in the table to the right (sorry but it won't let me attach a file for some reason).

Thanks

Capture.JPG