I've been toying with this all day, cant seem to get it to work


=IF((AND( I5:I9 = "b")), AVERAGE(K5:K9), "")

I want it to check All the I's for "B" and then after its done take another columns DATA and AVERAGE it based on the "B" Rows...


But its not working...ug, will I have to use an array or something? Theres gotta be something I'm missing.


-Bryan

YES

=AVERAGE(IF(I1:I10="B",K1:K10))

Array entered using CTRL+SHIFT+ENTER

Ok...I must be missing something, I put the formula in for the array and...it just stays there, how do i get it to print the value out in a cell?

Lol! I'm not sure what happened but it works now! It perfectly, thanks a ton!!!





-Bryan