Sumif, 2 criteria
 

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

Steve,

If you are looking at an "array formula" you'll need to press (all together)
the keys CTRL+SHIFT+ENTER; otherwise, it won't work.

Regards,
Robert

=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

Hi Steve

try
=SUMPRODUCT(--(N12:N1000="yes"),--(o12:o1000="L"),M12:M1000)

Cheers
JulieD

"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

Now that worked out perfectly. I don't know what I was doing differently. But
I greatly appreciate the help. Saved me a ton of time.

"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

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