| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Mode for multiple arrays based on criteria in another
Help! I have a workbook and am trying to calculate Mode (and other averages)
for arrays in one column from multiple worksheets containing scores (Column AB) based on meeting a condition (having a text value=Spanish, for example) in an array (Column AA) from multiple worksheets. I was using the following function, but cannot even get to the F2 and ctrl+shift+enter due to Excel telling me there is an error in my function. Can anyone please help me debug why or how to do this? Here is the function I am currently using: =IF(OR(AirForce!AA8:412="SPANISH",Army!AA8:AA52="S PANISH",Civilian!AA8:AA9="SPANISH",Marines!AA8:AA1 7="SPANISH",Navy!AA8:AA43="SPANISH"),MODE(AirForce !AB8:AB412,Army!AB8:AB52,Civilian!AB8:AB9,Marines! AB8:AB17,Navy!AB8:AB43),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Mode Function with 2 Criteria | Excel Worksheet Functions | |||
| returning a value based on mulitple criteria | Excel Worksheet Functions | |||
| Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Threaded Mode
