| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel AverageIF issue... PLEASE HELP!
I am looking to do an AverageIf across multiple sheets but only if the
value is greater than 0. Now when I do a standard average it works fine except it counts the cells with zero's against the overall average which would be resolved if the averageif command worked. Here is the command: =AVERAGEIF(Start:End!H3,"0") I have created a start and end sheet in the workbook so that it can capture all sheets in-between but I cannot get this to work. Any assistance would be appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AverageIF | Excel Discussion (Misc queries) | |||
| AVERAGEIF equivalent in excel 2000 | Excel Discussion (Misc queries) | |||
| Excel needs an AVERAGEIF function similar to SUMIF. Please! | Excel Discussion (Misc queries) | |||
| averageif | Excel Worksheet Functions | |||
| EXCEL -- want to do have ''averageif'' - like sumif function - H. | Excel Worksheet Functions | |||
Threaded Mode
