Consulting

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

Thread: SUMPRODUCT Step By Step - Part 1

  1. #21
    Quote Originally Posted by xld
    I hope you didn't take your computer in there.
    Regards,
    --------------------------------------------------------------------------------------------------------
    Shrivallabha
    --------------------------------------------------------------------------------------------------------
    Using Excel 2010 in Home / 2007 in Office on Win XP
    --------------------------------------------------------------------------------------------------------

  2. #22
    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
    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
  •