Hi,
that's only a small variation
Use IF-statements
leader: sum(if(Q1=="a1",1,0),if(Q2=="a3",1,0),if(Q3=="a1",1,0),...
manager: sum(if(Q1=="a2",1,0),if(Q2=="a1",1,0),if(Q3=="a1",1,0),...
...
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.