Formulas to calculate Total Goals and Completed Goals for the different combinations in the table.

%3CLINGO-SUB%20id%3D%22lingo-sub-2850159%22%20slang%3D%22en-US%22%3EFormulas%20to%20calculate%20Total%20Goals%20and%20Completed%20Goals%20for%20the%20different%20combinations%20in%20the%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2850159%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%20How%20can%20i%20calculate%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ETotal%20Goals%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECompleted%20Goals%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Busing%20Excel%20Formulas%20for%20the%20different%20combinations%20of%20sub%20teams%2C%20projects%20and%20quarters%20in%20the%20dummy%20table%20below%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ganeeyah25_0-1634284602630.png%22%20style%3D%22width%3A%20557px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F317716iE42069D8D20B1047%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Ganeeyah25_0-1634284602630.png%22%20alt%3D%22Ganeeyah25_0-1634284602630.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20sample%20workbook%20is%20also%20attached.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%26nbsp%3B%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146108%22%20target%3D%22_blank%22%3E%40Salmanul_Faries%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2850159%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

  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:

 

Ganeeyah25_0-1634284602630.png

 

The sample workbook is also attached.

  @Hans Vogelaar @Riny_van_Eekelen  @Haytham Amairah  @Salmanul_Faries  @Sergei Baklan 

1 Reply
A pivot table is perfect for questions like this one.