Results 1 to 4 of 4

Excel 2007 : Formula error:bring up an #VALUE! Error.

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2011
    Location
    Tasmania, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Post Formula error:bring up an #VALUE! Error.

    Hello,

    Currently working a spreadsheet where i am using the follow Formula that is bring up an #VALUE! Error.

    =IF(ROWS(C$90:C90)<=SUM(N(Availability!C$1256:C$1305<>"")),INDEX(Availability!C$1256:C$1305,MATCH(SMALL(COUNTIF(Availability!C$1256:C$1305,"<="&Availability!C$1256:C$1305),SUM(N(Availability!C$1256:C$1305=""))+ROWS(Availability!$C$90:C$90)),COUNTIF(Availability!C$1256:C$1305,"<="&Availability!C$1256:C$1305),0)),"")

    Using the same formula for actions in the spreadsheet but this one seems to be throwing out an error. Can anyone assist?

    Thanks.
    Last edited by burner007; 06-20-2011 at 06:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1