Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average IF with calculation
I have this problem:
IF O1 = "yes" then j1-p1+m1 but I need to do this from row1:row120 and then get the averages of row1:row120 Can anyone help me please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average IF with calculation
You can use an array formula to do this. Enter the following formula:
=AVERAGE(IF(O1:O20="yes",J1:J20-P1:P20+M1:M20,FALSE)) Since this is an array formula, you must press CTRL SHIFT ENTER rather than just ENTER when you first enter the formula and whenever you edit it later. If you do this properly, Excel will display the formula in the formula bar enclosed in curly braces { }. See www.cpearson.com/Excel/ArrayFormulas.aspx for much more info about array formulas. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Chris" wrote in message ... I have this problem: IF O1 = "yes" then j1-p1+m1 but I need to do this from row1:row120 and then get the averages of row1:row120 Can anyone help me please? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average IF with calculation
You stated half. If O1 = "yes" but what if it doesn't?
Tyro "Chris" wrote in message ... I have this problem: IF O1 = "yes" then j1-p1+m1 but I need to do this from row1:row120 and then get the averages of row1:row120 Can anyone help me please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use sub-totals and average in same calculation | Excel Worksheet Functions | |||
Difficult Average Calculation <HELP | Excel Worksheet Functions | |||
Calculation help from average total | Excel Worksheet Functions | |||
average calculation | Excel Discussion (Misc queries) | |||
Average Calculation | Excel Worksheet Functions |