Forum Discussion
Solved
Distinct Count number of completed Goals when all Task statuses in Goals are marked as completed
Good Day Excel users, what approach and formula can i use to solve this challenge on my subject (Distinct Count number of completed Goals when all Task statuses in Goals are marked as completed ). ...
See the attached version. I added a helper column to the first sheet.
I used formulas that will work in all versions of Excel. It would be easier in Excel 365.
See the attached version. I added a helper column to the first sheet.
I used formulas that will work in all versions of Excel. It would be easier in Excel 365.
HansVogelaar I have made some changes to the dummy table. How can i calculate the Total Goals and Completed Goals in the modified dummy table below:
The sample workbook is also attached.
@Riny_van_Eekelen @Haytham Amairah Salmanul_Faries SergeiBaklan
- Thank you. This solution worked for the calculations.