| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Problem
I'm trying to Average cells in a column that match a criteria in another
column and the column includes blanks. The problem i'm having is the formula is returning results average for the whole column and not the cell i want to match. Formula i'm using as follows. =AVERAGEA(IF(Data!$E$2:$E$4444="OG"<0,Data!D2:D44 4)) This is returning an average for the whole column and not just "OG". The formula works if i take out the <0 but then the average includes the blank cells. HELP!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Average ? and Divide by 0 error! | Excel Worksheet Functions | |||
| 12 Month Average | Excel Worksheet Functions | |||
| "Drop the lowest" in computing average | Excel Worksheet Functions | |||
| AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
| average, array and offsets | Excel Worksheet Functions | |||
Threaded Mode
