| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average with more than one IF statement
Hi,
I have used the formula from Bob Philips (10th Sept 06) in my worksheet: =AVERAGE(IF(ISNUMBER('eligible 2% - 1jan'!U3:U501),'eligible 2% - 1jan'!U3:U501)). I have to get the average also per department, so I have to check whether it is the correct department before it calculates the average. Not all info is filled in the U column. For the summation I have used the following: =SUMIF('eligible 2% - 1jan'!$A$3:$A$501,"mt*",'eligible 2% - 1jan'!$AB$3:$AB$501). ex* being a department starting with mt. But for average I have to omit the zero values. Any help is appreciated. Thanks, Lupe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Statement to Compute Average | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
Threaded Mode
