More than a simple sumif??

[Shhhh]

Hello all...

What i'm trying to do in words is this...

Sum all of column B:B if the corresponding cell in column A:A = either
an "L", or a "W".

so if A4 = "B" do not sum B4
but if A5 = "W" then sum B5 and move onto cell B6,,,

I'm sure what I'm asking for is possible it's just eluding me at the
moment!...


Thank you all!

 

[Mike H]

Maybe this

=SUMIF(A1:A25,"L",B1:B25)+SUMIF(A1:A25,"W",B1:B25)

Mike

 

[Shhhh]

Maybe this

=SUMIF(A1:A25,"L",B1:B25)+SUMIF(A1:A25,"W",B1:B25)

Mike

Worked great... Thank you!