Hello,

I have the following

A B C D
Functional Area Evolution Request Reference required man days required cost

Collateral ref001 10 100 $
Collateral ref001 5 50 $
Payment Incident ref002 15 80$


For each Functional Area in Column A, I would like to count the distinct number of requests from column B, sum the required Man Days from Column C and sum the required cost

The result would be:
Collateral: 2 distinct evolution requests, 15 M/D and 150 $
Payment Incident: 1 distinct evolution request, 15 man days and 80 $

I have downloaded the COUNTDIFF complementary macro from the internet, it works fine for a manual task in Excel. However, I would like to integrate it to a chart (Pivot Table) and this function is not recognized among the 11 standard functionalities in Excel (NB, Sum, NB Val, etc...)

Thanks for your help!