AVERAGEIF Function

[bflan0524]

hello
i have two columns of data,
Column A # of changes- its about 900 rows of data, and it provides the # of changes that have taken place, so it may say 0,1,2 etc
Column B : CES SCORE- again 900 rows, data can range from 0%-100%

in column C i want to average the # of scores in column B where column A shows 0
so an average of all the scores in column B when column A=0

i had =AVERAGEIF( B:B,A:A=0,B:B) but i got a DIV/0 error

 

[estevaoba]

Try this:

=AVERAGEIF(A:A,0,B:B)

Godspeed!

 

[bflan0524]

Try this:

=AVERAGEIF(A:A,0,B:B)

Godspeed!

thank you!