Sumif problems - meeting 2 criteria then sum

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

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

Top