| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGE IF in array not working
Hi
I have the following data: A B 22 70% 29 20% 22 90% 24 10% I want to calculate the AVERAGE of the values in Column B, where Column A's value is "22". I.e. the answer to the above example will be 80%. I have tried the {=AVERAGE(IF(A1:A4="22",B1:B4))} but it does not work? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGE IF in array not working
Hi,
No quotes around the 22 and array enter# =AVERAGE(IF(A1:A4=22,B1:B4)) Mike "WildWill" wrote: Hi I have the following data: A B 22 70% 29 20% 22 90% 24 10% I want to calculate the AVERAGE of the values in Column B, where Column A's value is "22". I.e. the answer to the above example will be 80%. I have tried the {=AVERAGE(IF(A1:A4="22",B1:B4))} but it does not work? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGE IF in array not working
Try it without "" and make sure you enter using ctrl+shift+enter
=AVERAGE(IF(A1:A4=22,B1:B4)) -- Don Guillett Microsoft MVP Excel SalesAid Software "WildWill" wrote in message ... Hi I have the following data: A B 22 70% 29 20% 22 90% 24 10% I want to calculate the AVERAGE of the values in Column B, where Column A's value is "22". I.e. the answer to the above example will be 80%. I have tried the {=AVERAGE(IF(A1:A4="22",B1:B4))} but it does not work? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGE IF in array not working
Thanks Mike H!
Considering the following derivative, please advise: A B 22 Cat 29 Bat 22 Tax 24 Bat 22 Cat I want to calculate the total number (COUNT) of the occurences of "Cat" in Column B, where where Column A's value is "22". I.e. the answer to the above example will be 2. "Mike H" wrote: Hi, No quotes around the 22 and array enter# =AVERAGE(IF(A1:A4=22,B1:B4)) Mike "WildWill" wrote: Hi I have the following data: A B 22 70% 29 20% 22 90% 24 10% I want to calculate the AVERAGE of the values in Column B, where Column A's value is "22". I.e. the answer to the above example will be 80%. I have tried the {=AVERAGE(IF(A1:A4="22",B1:B4))} but it does not work? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVERAGE IF in array not working
Thanks Don!
"Don Guillett" wrote: Try it without "" and make sure you enter using ctrl+shift+enter =AVERAGE(IF(A1:A4=22,B1:B4)) -- Don Guillett Microsoft MVP Excel SalesAid Software "WildWill" wrote in message ... Hi I have the following data: A B 22 70% 29 20% 22 90% 24 10% I want to calculate the AVERAGE of the values in Column B, where Column A's value is "22". I.e. the answer to the above example will be 80%. I have tried the {=AVERAGE(IF(A1:A4="22",B1:B4))} but it does not work? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Array | Excel Discussion (Misc queries) | |||
| Average array | Excel Worksheet Functions | |||
| Array average question | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Average Array Formula | Excel Worksheet Functions | |||
Linear Mode
