Hello DocAElstein,

Tried out your macro. It works up to a certain extent.

1. When new data is entered on the subsequent rows, the values do not refresh on the summary sheet.
2. I have a similar template for other tasks (same formatting, same criteria, etc.) but no results appear in the summary sheet.
3. In case a criteria does not have any tasks, can the value shows as "0" (Zero).

Thanks
Siyab