SumProduct with criteria list
Hi Sige
Perhaps I'm misunderstanding you.
With A1:A6 containing Sige, SIGE, sIGE, SigE, sIGe, sIgE
With G1:G20 containing SIGE1 - SIGE20
then with
=SUMPRODUCT(--(ISNUMBER(FIND(A1:A6;G1:G20)))
I return the correct result of 1.
The rest of the formula is immaterial to this argument.
--
Regards
Roger Govier
"Sige" wrote in message
oups.com...
Hi Roger,
=SUMPRODUCT(--(ISNUMBER(FIND(A1:A6;G1:G20)));--(H1:H20))
In my practical example I can tell ... the results are not as they
should.
If A1 = Sige (mind the small caps) (not even bothering the other
criteria...)
My range G1:G20 = SIGE1 till SIGE20 (mind the CAPITALS)
It returns a correct result?
|