mutiple tests

M

Mikev

I was to sumif on multiple tests, e.g. column c:c = lost and column g:g=
""name" then sum column kk.

Is this possible?

thanks Mike
 
M

Mike H

Hi,

Try this

=SUMPRODUCT((C1:C15="Lost")*(G1:G15="Name")*(K1:K15))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
D

Don Guillett

Don't use entire column
=sumproduct((c2:c22="lost")*(g2:g22="name")*k2:k22)
 
Top