E
Eki75
I'm trying to figure out a conditional average formula that ignores empty
cells.
Column a is demographic information (e.g., BLONDE,BRUNETTE,RED,GRAY,BLACK)
Column b is a number
I want to get an average of the numbers in Column B for which Column
A=BLONDE--BUT I want empty cells to be ignored.
I'm using: =SUMIF(B5:B16,"BLONDE",C5:C16)/COUNTIF(B5:B16,"BLONDE")
This works great except that it is counting empty cells. Any suggestions?
cells.
Column a is demographic information (e.g., BLONDE,BRUNETTE,RED,GRAY,BLACK)
Column b is a number
I want to get an average of the numbers in Column B for which Column
A=BLONDE--BUT I want empty cells to be ignored.
I'm using: =SUMIF(B5:B16,"BLONDE",C5:C16)/COUNTIF(B5:B16,"BLONDE")
This works great except that it is counting empty cells. Any suggestions?