Mar 28 2005, 07:57 PM
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.
Mar 29 2005, 06:51 AM
Array entered using CTRL+SHIFT+ENTER
Mar 29 2005, 11:56 AM
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?
Mar 29 2005, 12:05 PM
Lol! I'm not sure what happened but it works now! It perfectly, thanks a ton!!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here