I have a data sheet with a series of dates in the first column, error types in the next column and minutes taken to resolve the error in the last.
I want to get a total of time taken for each error type for any given date, can I use an array formula to do this and if so can somebody give me a headstart as to how as I am getting nowhere fast.
Date: error type: minutes taken to resolve
want end up selecting a date and a error type and having a total time lost for that error on that date.
I want to get a total of time taken for each error type for any given date, can I use an array formula to do this and if so can somebody give me a headstart as to how as I am getting nowhere fast.
Date: error type: minutes taken to resolve
want end up selecting a date and a error type and having a total time lost for that error on that date.
