Thread: #Value! Same formula, different outcomes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Texas Aggie Texas Aggie is offline
external usenet poster
  
Posts: 74
Default #Value! Same formula, different outcomes
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
Reply With QuoteReply With Quote