| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGE a range in a column if another column's range equals a val
Hi,
In 2007: =AVERAGEIF(D1:D4,1,A1:A4) Where D1:D4 contain the numbers you are looking for and you want to average A1:A4. In 2003: =SUMIF(A1:A8,1,B1:B8)/COUNTIF(A1:A8,1) in this case the 1's are in column A and the numbers you want to average in B. -- If this helps, please click the Yes button Cheers, Shane Devenshire "bob$" wrote: AVERAGE a range in a column if a a value in a different column equals "1" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF a value within a range equals any value in an array/list | Excel Worksheet Functions | |||
| Formula to take average from column range matching another | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
