On Thu, 3 Mar 2005 18:41:01 -0800, JWCardington
wrote:

Ron,
Thank you very much for your last responce. It was exactly what I needed to
get me on the right track. I did have to hange my IF statement to look at
the precedents of B1:. At first I was having difficulty with it until I had
to include ALL precedent ranges that were invloved to create the final value
in B1. Below are the ranges I had to set in my If statement.

(I15:J24,N15:N24,O15:O25,H36:H140).

Once I did that it worked perfectly!

Again,
Thank you!!!!!!

You're welcome. Glad you got things working OK.
--ron