AVERAGEIFS Error

I

ianwillo123

Joined
Nov 12, 2010
Messages
1
Reaction score
0
Hi All.

I am performing an averageifs function in excel. My functions is below:

=AVERAGEIFS(Table_RemedyFeeds[Ticket Resolution Time],Table_RemedyFeeds[Ticket Resolution Time],"<05:00",Table_RemedyFeeds[MIM/No Mim],"MIM")

So this basically returns the average of Ticket Reolution time, when fields MIM/NO MIM = MIM and Ticket Resolution Time is less than 5 mins. The result I get for this is 01:02.

However, when I copy the raw data, remove all the fields not required and just perform and ordinary average function to check the data, I get 01:24.

Can anyone please help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i use averageifs function? 2
How do I set up a formula to give me an average based on IF? 1
Time query 9
//time calculations 4
How to enter start and end date/time in excel based on some specific value. 7
Rate of change 4
Peak call times/hours 2
Time Format 1

Top