Thomas Kuriakose
Active Member
Respected Sirs,
Kindly find attached a workbook with three tabs , "Data", "Pivot Summary" and "Formula Summary".
The data tab needs to be summarized as per the pivot summary and is working. There are some tables with shorter data with the same format.
Kindly guide and suggest if there is a formula method to arrive at the summary as shown in formula summary tab.
Thank you very much for your support always,
very much appreciated,
with regards,
thomas
Kindly find attached a workbook with three tabs , "Data", "Pivot Summary" and "Formula Summary".
The data tab needs to be summarized as per the pivot summary and is working. There are some tables with shorter data with the same format.
Kindly guide and suggest if there is a formula method to arrive at the summary as shown in formula summary tab.
Thank you very much for your support always,
very much appreciated,
with regards,
thomas
Attachments

602.3 KB Views: 5