|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 11th, 2005, 02:49 PM
|
|||
|
|||
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  1000 i am looking forcells with "L". If they match up in the same row, i want to sum m12:m1000. Can anyone help? Thanks, Steve 
|
|
#2
January 11th, 2005, 02:59 PM
|
|||
|
|||
|
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
|
|
#3
January 11th, 2005, 03:00 PM
|
|||
|
|||
|
=sumproduct(--(n12:n1000 ="yes"),--(o12
1000="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 1000 i am looking forcells with "L". If they match up in the same row, i want to sum m12:m1000. Can anyone help? Thanks, Steve
|
|
#4
January 11th, 2005, 03:01 PM
|
|||
|
|||
|
Hi Steve
try =SUMPRODUCT(--(N12:N1000="yes"),--(o12 1000="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 1000 i am looking forcells with "L". If they match up in the same row, i want to sum m12:m1000. Can anyone help? Thanks, Steve
|
|
#5
January 11th, 2005, 04:09 PM
|
|||
|
|||
|
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 1000="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 1000 i am looking forcells with "L". If they match up in the same row, i want to sum m12:m1000. Can anyone help? Thanks, Steve
|
|
#6
January 12th, 2005, 04:05 AM
|
|||
|
|||
|
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 1000="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 1000 i am looking forcells with "L". If they match up in the same row, i want to sum m12:m1000. Can anyone help? Thanks, Steve
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Complex query criteria - desperate appeal | Ted Allen | Running & Setting Up Queries | 5 | November 17th, 2004 06:14 PM |
| SUMIF help- 'criteria' doesn't allow formulas? | JAnderson | General Discussion | 4 | July 28th, 2004 07:22 PM |
| SUMIF vs SUM(IF(..)) vs SUMPRODUCT | Harlan Grove | Worksheet Functions | 7 | July 1st, 2004 10:22 PM |
| SUMIF vs SUM(IF(..)) vs SUMPRODUCT | Harlan Grove | General Discussion | 7 | July 1st, 2004 10:22 PM |
| SUMIF w/ Multiple criteria?? | Jana | Worksheet Functions | 3 | April 17th, 2004 10:26 AM |
Linear Mode
