How to get summary table with unique count and sum value using VBA

Dear Forum experts,

It is a continuity of my previous thread and link has been given below. One of the expert helped me a lot and as much as he can, where as I did not pen down my requirement properly. But now, i have properly listed my requirements and model excel sheet has been attached for your kind reference and looking for VBA code / Macro.

https://www.excelforum.com/excel-pro...-countifs.html

I have a set of individual hospital data, which provides services by month wise and I want to extract only new hospital which newly joined in this month and provides services. We can easily identify the "New" hospital in the column J and which has been indicated as "1". In a month, those new hospital might have been reported 2 times. We want to get unique hospital details based on Hospital Unique ID in the column "E". All the requirement has been clearly given in the attached excel sheet.

Requirement : 1- Unique count value based on multiple criteria (State/Province wise and Month wise) as well as particular column cell has "1" value.

Requirement : 2- Unique sum (cumulative) value based on multiple criteria (State/Province wise and Month wise) as well as particular column cell has "1" value.

Thanks for your support.