Hi Harkawat, help me out here please, what do the double "--" mean in a
formula? Much appreciated.

"N Harkawat" wrote:

=sumproduct(--(n12:n1000 ="yes"),--(o12:o1000="L"),(m12:m1000))

"Steve" wrote in message
...
I have seen about a dozen entries with that subject. I can't get a
single
of oneof them to work. Am I missing something? In the range n12:n1000 I am
looking for cells with "yes" and in the range o12:o1000 i am looking for
cells with "L". If they match up in the same row, i want to sum m12:m1000.
Can anyone help?

Thanks,
Steve