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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>