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.
Bookmarks