mutiple tests
 

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

mutiple tests
 

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

mutiple tests
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mikev" wrote in message
...


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