chrischilton01
New Member
- Joined
- Jun 9, 2014
- Messages
- 19
I am trying to calculate the mode of our turn-around times for cases we handle as follows:
In column N, which contains whole numbers, which I want to obtain the mode values of, if:
{=MODE(IF([Jan12_May14_Closed_Cases.xlsx]report1401715985583!$A$2:$A$56366=J2,IF([Jan12_May14_Closed_Cases.xlsx]report1401715985583!$I$2:$I$56366<J1,[Jan12_May14_Closed_Cases.xlsx]report1401715985583!$M$2:$M$56366)))}
I have tried adding in a AND statement but cannot seem to get this to work, any ideas?
In column N, which contains whole numbers, which I want to obtain the mode values of, if:
- Column A equals the name of a person in my team reference by cell J2
- if the date in column I was greater than 31/12/12 (referenced J1) and less than 01/01/2013 (referenced by K1)
{=MODE(IF([Jan12_May14_Closed_Cases.xlsx]report1401715985583!$A$2:$A$56366=J2,IF([Jan12_May14_Closed_Cases.xlsx]report1401715985583!$I$2:$I$56366<J1,[Jan12_May14_Closed_Cases.xlsx]report1401715985583!$M$2:$M$56366)))}
I have tried adding in a AND statement but cannot seem to get this to work, any ideas?