Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averages
Dear Wizards,
Col A has 200 - 300 entries randomly occuring limited to the integers 0-19. Col B has numeric values. What formula can I use to figure the average of all of col B's values that are accross from (associated with) a col A value of '7' then '8' then '9' etc. Thanks for being there. Sam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averages
Well, the average is just the sum divided by the count, so I'd use sumif and
countif: =sumif(a:a,7,b:b) / countif(a:a,7). If you put the series of numbers 0-19 in d1:d20, then you can use cell references for the 2nd argument in the sumif and countif functions. In e1: =sumif(a:a,d1,b:b) / countif(a:a,d1). Then autofill that down through e20. --Bruce "Metolius Dad" wrote: Dear Wizards, Col A has 200 - 300 entries randomly occuring limited to the integers 0-19. Col B has numeric values. What formula can I use to figure the average of all of col B's values that are accross from (associated with) a col A value of '7' then '8' then '9' etc. Thanks for being there. Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averages in pivot tables | Excel Discussion (Misc queries) | |||
Function for generating monthly & weekly averages | Excel Worksheet Functions | |||
Range of averages | Excel Discussion (Misc queries) | |||
Trouble Sorting Averages of Randomly Generated Numbers | Excel Discussion (Misc queries) | |||
calculating averages | Excel Discussion (Misc queries) |