Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Where do I put SUMIF...revised

  1. #1
    New Member
    Join Date
    Mar 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    First a word of thanks to all that have given advice over the last few days. I finally got my function to work on one spread sheet now I modified it to use with different data and need to add a SUMIF,

    The equation so far is this: =IF(ISERROR(VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE)),"HELP",VLOOKUP($A23&D$3,RIS_GR_MAINS!$D$2:$E$503,2,FALSE))

    The lookup ($A23&D$3)=19176, this appears twice on the referenced sheet one value is 1000 the other is 500. I need to add a SUMIF in my function to find all instances of $A23&D$3 and add them together, in this case return 1500. Please ignore the term "HELP" in the equation, it is a flag for me elsewhere and will be replaced with "" when everything works properly.

    Any takers? Happy Easter to all!!

    [ This Message was edited by: rsw8679 on 2002-03-29 13:57 ]

    [ This Message was edited by: rsw8679 on 2002-03-29 14:18 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Calgary, Alberta Canada
    Post Thanks / Like
    2 Post(s)
    1 Thread(s)


    Vlookup will just locate the first instance that meets your lookup value.

    If you clearly describe your challenge, someone is sure to provide a good alternative.

    A clear concise example with the results that you expect is often very useful.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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