Hi,
These two functions will act differently, although I'm not sure why #Value!
appears without knowing the content of the cells being referenced.
When you type in =IF('09'!C7:N70,True,False) In cell C2 on your specs
sheet, it will test the value C70. When you type the same formula in D2 it
will test D70. Because you are referencing a range, ='09'!C7:N7 will give
you an item from that range, indexed by the column, whereas
=Average('09'!C7:N7) will give you the average of the range. I am guessing
that the #Value! error is due to the value in D7.
If you are not trying to test individual values being 0 then let us know
what you are trying to test and someone will be able to help with a formula.
If this is what you were trying to do then try looking at D7 to see if the
error is coming from there.
Sean.
--
(please remember to click yes if replies you receive are helpful to you)
"Texas Aggie" wrote:
Howdy,
I have the formula =AVERAGE(IF('09'!C7:N70,'09'!C7:N7)) placed in both cell
C2 and D2 in a worksheet titled "Specs Sheet". Both cell are reference to
sheet "09" in C2 the formula works correctly. In D2 the formula returns
#Value!.
--
Silverbird Designs @ www.silverbirddesigns.com
Fighting Texas Aggie Class of 2009