PDA

View Full Version : SUMIF problem

nstaward
10-05-03, 20:06
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
sugarflux
10-06-03, 06:01
=SUMIF(criteria in column2,"WIN",values in column1)
=SUMIF(criteria in column2, "LOSE", values in column1)

sugarflux :0p
Kabuki_jo
10-13-03, 13:54
I think this is the formula you want

=SUMIF(B1:B10,"win" ,A1:A10) + SUMIF(B1:B10,"lose",A1:A10)
nstaward
10-13-03, 15:12
Yeah, i used that one, thanks