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