Results 1 to 4 of 4

INDIRECT formula giving #VALUE error when adding COLUMN() and not sure how to fix..

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2008
    Location
    Houston
    MS-Off Ver
    Office 365
    Posts
    85

    INDIRECT formula giving #VALUE error when adding COLUMN() and not sure how to fix..

    Hi All,

    Hoping someone can help with my ignorance. I've got a sumproduct formula that's giving me issues.

    Currently the formula is:

    =SUMPRODUCT(--('2012 Schedule'!$B$2:$JC$2<=$A2),'2012 Schedule'!$B$3:$JC$3)
    I'd like to update to:

    =SUMPRODUCT(--('2012 Schedule'!$B$2:$JC$2<=$A2),INDIRECT("'2012 Schedule'!$B$"&COLUMN(C1)&":$JC$"&COLUMN(C1)))
    But, this gives me the #VALUE error and not sure how to fix.

    Any help is greatly appreciated.

    Thanks,
    Cullen
    Last edited by Cullen8; 01-26-2012 at 02:36 PM.

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