How to average data with a dynamic range

S

Sharon

Here is the problem I have

Col1 Col2
2.3 1
3.4 1
5.6 1
7.8 2
2.3 2
5.7 2
6.1 3
3.2 3

I want average the value in col 1 only when they have the same number in
col2.
please help! Thanks!
 
D

Don

Sharon, not sure the question. I think you could create a thrird column to
check and either put the average or the number you want then average. so for
the first line, =if(round(a1,0)=b1,a1) would put 2.3 in column 3 only if the
rounded amount (2) = 1. I did not see any matches in column 1 and 2 which is
why I am confused
 
R

Roger Govier

Hi Sharon

In cell C1
=SUMIF(B:B,ROW(C1),A:A)/COUNTIF(B:B,ROW(C1))
Copy down through C2:C3
 
Top