Multiple criteria
Hi, i have this code:
=sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100)
This code retrieve numbers. I need a code, just like that, a code for
multiple criteria, that retrieve text.
Can this be done?
Thanks!
|