| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Average (2 conditions)
I have in A1:A100 either numbers or #N/A. In B1:B100 there is either TRUE or FALSE. I want to calculate the average of A1:A100 but only of those rows where there is an actual number (Not #N/A) and where condition in column B is true. I need this to be made in one formula without adding any more column in the sheet! is it possible ? Thanks Paolo -- kayard ------------------------------------------------------------------------ kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716 View this thread: http://www.excelforum.com/showthread...hreadid=569791 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
| Conditional Average | Excel Discussion (Misc queries) | |||
| Conditional Average | Excel Worksheet Functions | |||
| Conditional Average Ignoring Blanks | Excel Worksheet Functions | |||
| Extend conditional formatting to more than 3 conditions | Excel Worksheet Functions | |||
Threaded Mode
