View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default 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?