Forum Discussion
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.
Could you attach a sample workbook? Thanks in advance.
Hi,
Please find this file. This will automatically update the results as you extend or change the main data.
Certain functions used in this will work only in Excel 365.
Thank you!!
- Thank you.
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
