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

=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??