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
