M Mikev Mar 2, 2010 #1 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
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 Mar 2, 2010 #2 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.
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 Mar 2, 2010 #3 Don't use entire column =sumproduct((c2:c22="lost")*(g2:g22="name")*k2:k22)
