Forum Discussion
Subiloo39
Aug 14, 2023Copper Contributor
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
1 Reply
Sort By
- SergeiBaklanDiamond Contributor
Could you please give bit more details - how "no. yp" are calculated and, in general, what is the logic behind.