| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding or to previously provided Average If Array function
Hi,
Jacob Skaria helped me out by providing the following formula. Thank you Jacob =IF(COUNTIF(Q3:Q4,"4"),MAX(3,AVERAGE(IF(score0,s core))), AVERAGE(IF(score0,score))) entered as an array. but I'm here again! I need to add an OR (I think!) 'cos now I've been asked to amend this so that a score of 4 in either Q3 or Q4 OR a score of 3 in either Q5 or Q6 means that the average cannot be lower than 3. Any of these cells can contain a zero. Q1:Q35 is the named range score. If anyone can help me that would be more than brilliant! Cheers Diddy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding if to Average If Array function | Excel Worksheet Functions | |||
| Adding rows to the data array used in an Index function | Excel Discussion (Misc queries) | |||
| Adding error suppression to AVERAGE FUNCTION | Excel Worksheet Functions | |||
| Small Array is too big for AVERAGE Function? | Excel Worksheet Functions | |||
| Can a cell refer to range name/array of data previously set? | Excel Discussion (Misc queries) | |||
Threaded Mode
