kate_suzanne wrote:
Here are the "allotments" for each category:

P=1
S=5
F=3
A=5
E=1

Their totals are per semester...I would clear the spreadsheet of
names and numbers each semester but leave the formulas in place to
use again second semester.

Let me know of anything else I can answer.


Hi need an explanation about the formula in row 3, i.e.:

=IF(AND($B$2=0,G2="P"),0,IF(AND($C$2=0,G2="S"),0,I F(AND($D$2=0,G2="F"),0,IF(AND($E$2=0,G2="A"),0,IF( AND($F$2=0,G2="E"),0,LOOKUP(G2,{"P","S","F","A","E ","T","B","BB","BBB","TB","TBB",""},{3,3,3,3,3,2,2 ,1,0,1,0,3}))))))


try to describe what does it do, so I can understand it, expecially the
lookup... Are those the points you are giving?

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy