Hi,

Try this

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

--
Mike

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


"Mikev" wrote:



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