Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for conditional averaging or "Averageifs" function for '02
You can use AVERAGE(IF(...)) entered as an array formula by hitting
CTRL+SHIFT+ENTER. Alternativaley, you can do SUMIF(...)/COUNTIF(...) entered as a regular formula. Dave -- Brevity is the soul of wit. "threee11" wrote: I have Office '02 at my workplace and am tryin to do some conditional averaging (i.e. calculate averages of numbers in column C if same row in column B is 'Bravo'), I know in '07 there is an averageifs function, any idea of something similar for '02 or '03 (home computer)? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Function to next Column | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |