Forum Discussion

Subiloo39's avatar
Subiloo39
Copper Contributor
Aug 14, 2023

Excel formula to add up info based on attendance over a number of Cycles/Quarters

I would like to calculate how many males attended C1 and C2 separately but cant figure out the formula in excel (where the number one appears in each Cycle indicates they have attended). 
If anyone can help which this would be much appreciated, then I can continue with females and ages etc.

I have attached an image for your information

Resources