mutiple tests

  • Thread starter Thread starter Mikev
  • Start date Start date
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
 
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't use entire column
=sumproduct((c2:c22="lost")*(g2:g22="name")*k2:k22)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use dynamic column reference without R1C1 3
Nested IF / SUMIF statements 2
Filtering with SUMIFS 1
Sum up 2 or more columns under same SUMIF criteria 2
SUMIF Range 8
Sumif() with dates 10
code question 2
Sumif & Sort 3

Back
Top