Hi All. I'm new to here, but I've been using excel for years. I am
creating a worksheet to track my Girl Scout's awards. I have it all
done EXCECT for one formula. I can't get it right. I'm going to TRY to
explain this. The ( is the cell address) then number in front is the
answer to adding columns elsewere.

ANSWER(a114) 2(b144) 1(c144) 0(d144) 1(e144) 1(f144) 1(g144)

OK I hope that makes since.

What I want it to do to answer "c" IF b=2, and between c, d, e, =2 BUT
only 1 in each letter count, AND f=1 and g=1

IF not then it needs to answer "P" if the sum is 0 then it needs to
answer a blank if all are 0.


--
RobertaS54
------------------------------------------------------------------------
RobertaS54's Profile: http://www.excelforum.com/member.php...o&userid=37771
View this thread: http://www.excelforum.com/showthread...hreadid=573468