Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 23 of 23

Thread: SUMPRODUCT Step By Step - Part 1

  1. #21
    VBAX Expert shrivallabha's Avatar
    Joined
    Jan 2010
    Location
    Mumbai
    Posts
    744
    Location
    Quote Originally Posted by xld
    I hope you didn't take your computer in there.
    Regards,
    --------------------------------------------------------------------------------------------------------
    Shrivallabha
    --------------------------------------------------------------------------------------------------------
    Using Excel 2016 in Home / 2010 in Office
    --------------------------------------------------------------------------------------------------------

  2. #22
    VBAX Newbie
    Joined
    Sep 2015
    Location
    Bangalore
    Posts
    1
    Location
    Great articles about basic Sumproduct....Thanks but 1 question about this, the code- =A2:A20="test" in B2 will give true/false or #Value error ?

  3. #23
    Site Admin VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,008
    Location
    That formula isn't anything to do with SUMPRODUCT, if it isn't to do with it i'll move it to the general Excel forum.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

Posting Permissions

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