Hi,
I have a spreadsheet which contains a phone system call queues, I need to find the same item for 3 potential queues each month, I can do this easily using Index formula for a single queue.
Searching Col K for the time info I'm looking for, N2 is the month name to search for, Col A is where to search for the month name, Col B is the Phone queue name col.
=IFNA(INDEX($K:$K, MATCH(1, (N2=$A:$A) * ("Queue1"=$B:$B), 0)),"0")
What I'm trying to do is combine 3 different queue names into the one formula (end result is to get the average of the 3), for testing I currently have 3 separate cells with the different queue names in the formula and then I can avg the 3 separate cells, wishing to only end up with the one formula cell per month.
I'm not sure how to OR/AND the 3 "Queue1" "Queue2" "Queue3" into * ("Queue1"=$B:$B) correctly and average then them without having to repeat a index lookup 3 times in a single Average formula.
Any pointers are appreciated in keeping the formula short and concise.
Thank you
I have a spreadsheet which contains a phone system call queues, I need to find the same item for 3 potential queues each month, I can do this easily using Index formula for a single queue.
Searching Col K for the time info I'm looking for, N2 is the month name to search for, Col A is where to search for the month name, Col B is the Phone queue name col.
=IFNA(INDEX($K:$K, MATCH(1, (N2=$A:$A) * ("Queue1"=$B:$B), 0)),"0")
What I'm trying to do is combine 3 different queue names into the one formula (end result is to get the average of the 3), for testing I currently have 3 separate cells with the different queue names in the formula and then I can avg the 3 separate cells, wishing to only end up with the one formula cell per month.
I'm not sure how to OR/AND the 3 "Queue1" "Queue2" "Queue3" into * ("Queue1"=$B:$B) correctly and average then them without having to repeat a index lookup 3 times in a single Average formula.
Any pointers are appreciated in keeping the formula short and concise.
Thank you