Sumif, 2 criteria

[Guest]

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 o121000 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

 

[Guest]

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

 

[N Harkawat]

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

 

[JulieD]

Hi Steve

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

Cheers
JulieD

 

[Guest]

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.

 

[Guest]

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