Sumif, 2 criteria

S

Steve

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:eek:1000 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
 
C

cmart02

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
 
J

JulieD

Hi Steve

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

Cheers
JulieD
 
S

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.
 
S

Sir Paul

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP or SUMIF for Multiple Criteria 2
Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
Multiple Columns in Sum Range using SUMIFS 1
sumif issues 1
Sumif apllying to all sheets in workbook 2
Specifying comparision criteria with SUMIF() 2
SUMIFS, one criteria range, multiple criteria 2

Top