I'm having trouble with the formula below, Im getting "Too few arguments" . Where am i going wrong with the formula below?
CELL H2 FORMULA =IFERROR(AVERAGEIFS(C2:C11,"<>100%", C1:E1,G2,A2:A11,H1)"CHECK")
So here it goes:
I have a list of customers in column A and a number for how long the call has been open in colum Z. I want to search a particular customer and average how long thier calls have been open. But i dont want to use piviot tables.
I have a list that contains numbers and some text values. I want to calculate average of the numbers in the list (leaving text out ofcourse). I've been trying many things like SUMIF()/COUNTIF(); but I can't make it work.
I am using Excel 2003