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
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