# Thread: SUMIF problem

1. Registered User
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. Registered User
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. Registered User
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)

4. Registered User
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
•