| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to average based on criteria
In column B there are letters "A,AC,P,PB,S".
In column U there are numbers. need formula that searches column B for the letters "A" and "AC" then goes to column U and averages those numbers that meet the criteria. I have Excel 2003 Thx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to average based on criteria
=AVERAGE(IF((B2:B20={"A","AC"}),U2:U20))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "drd" wrote in message ... In column B there are letters "A,AC,P,PB,S". In column U there are numbers. need formula that searches column B for the letters "A" and "AC" then goes to column U and averages those numbers that meet the criteria. I have Excel 2003 Thx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to average based on criteria
Thank you. It worked great:)
"Bob Phillips" wrote: =AVERAGE(IF((B2:B20={"A","AC"}),U2:U20)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "drd" wrote in message ... In column B there are letters "A,AC,P,PB,S". In column U there are numbers. need formula that searches column B for the letters "A" and "AC" then goes to column U and averages those numbers that meet the criteria. I have Excel 2003 Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average one column based on criteria from another | Excel Discussion (Misc queries) | |||
| Need to average division of two columns based on criteria | Excel Discussion (Misc queries) | |||
| Calculate average based on date and other criteria | Excel Discussion (Misc queries) | |||
| Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
| caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
Linear Mode
