# average if number

1. ### weekdaty Average IFs formula

Hello, 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") <tbody> a b c d e f g H I J K L M N O P Q R 1 Name John Jacob Jill 1 2...
2. ### Average excluding zero

I need to average a list of numbers, excluding the number zero. Example list: 1, 0, 2, 2, 0, 5, 0. How can you average 1, 2, 2, 5 AND exclude the zeros from calculation? Thanks!

Hello, 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. E.g. Column 1.A................Z...
4. ### Average if the cell content is a number

Hi 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 Thanks Rajesh