Results 1 to 4 of 4

Thread: SUMIF problem

  1. #1
    Join Date
    Aug 2002
    Location
    Cambridge, England
    Posts
    47

    Unanswered: SUMIF problem

    Hi

    I have column A (numbers) which has postivie values, and column B (text) with either Win, Lose, None or is empty. How do I calculate the sum of all values in A where the corresponding value in B is Win or Lose? I have got to =SUMIF(B1:B10,x,A1:A10) but can't figure out the expression to get Win OR Lose in the criteria.

    Thanks

  2. #2
    Join Date
    Aug 2003
    Posts
    106
    =SUMIF(criteria in column2,"WIN",values in column1)
    =SUMIF(criteria in column2, "LOSE", values in column1)

    sugarflux :0p

  3. #3
    Join Date
    Oct 2003
    Posts
    61
    I think this is the formula you want

    =SUMIF(B1:B10,"win" ,A1:A10) + SUMIF(B1:B10,"lose",A1:A10)
    Nobody dies a virgin because life screws us all!

  4. #4
    Join Date
    Aug 2002
    Location
    Cambridge, England
    Posts
    47
    Yeah, i used that one, thanks

Posting Permissions

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