| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumif problems - meeting 2 criteria then sum
Column M can be A, B, C, D or E
COlumn N is $amts Q can be P0, P1, P2 or P3 sum col n if col m = a and col q = p1 =SUMIF($M$14:$M$53,AND($M$14:$M$53="A",$Q$14:$Q$53 ="p1"),$N$14:$N$53) can't get this formula to give me the correct answer... instead it gives me Nil all the time... why?? |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--($M$14:$M$53="A"),--($Q$14:$Q$53="p1"),$N$14:$N$53)
"Kikkoman" wrote: Column M can be A, B, C, D or E COlumn N is $amts Q can be P0, P1, P2 or P3 sum col n if col m = a and col q = p1 =SUMIF($M$14:$M$53,AND($M$14:$M$53="A",$Q$14:$Q$53 ="p1"),$N$14:$N$53) can't get this formula to give me the correct answer... instead it gives me Nil all the time... why?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| SUMIF using VLOOKUP as criteria | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
