Forum Discussion
Ganeeyah25
Oct 15, 2021Copper Contributor
Formulas to calculate Total Goals and Completed Goals for the different combinations in the table.
How can i calculate the Total Goals and Completed Goals using Excel Formulas for the different combinations of sub teams, projects and quarters in the dummy table below:
The sample workbook is also attached.
@Hans Vogelaar @Riny_van_Eekelen @Haytham Amairah @Salmanul_Faries @Sergei Baklan
1 Reply
- JKPieterseSilver ContributorA pivot table is perfect for questions like this one.