Consulting

Results 1 to 3 of 3

Thread: Solved: Error in Sumproduct

  1. #1
    VBAX Mentor asingh's Avatar
    Joined
    Jul 2005
    Posts
    307
    Location

    Solved: Error in Sumproduct

    Hi,

    Please could someone tell, why the first sumproduct is not working, and the second one is..so is the third one...!

    When evaluating for a numerical using INDIRECT(ADDRESS(ROW(),column#)) I get an error. Same thing happens..when I try this in array functions.

    Attached is the sheet.

    thanks and regards,

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,292
    Location
    Because it returns cell references, not values

    =SUMPRODUCT(--(N(INDIRECT(ADDRESS(ROW(),2)))=$H$5:$H$17))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Mentor asingh's Avatar
    Joined
    Jul 2005
    Posts
    307
    Location
    Hi,

    thanks XLD..works perfect with the N operator.....

    marking as solved...

    thanks and regards,

    asingh

Posting Permissions

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