mutiple tests

[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

 

[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.

 

[Don Guillett]

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