Hi
have you entered the formula with CTRL+SHIFT+ENTER?.

--
Regards
Frank Kabel
Frankfurt, Germany


Thank you for replying quickly.

I tried that formula but it seems like the if statement doesn't work
because it takes the average of the entire G1:G100 range. Do you know
how to fix this.

Thank you

Morry


---
Message posted from http://www.ExcelForum.com/