In excel you can summarize the pivot table by right clicking the value you want to summarize, then there is a option called Summarize Value By and there you will have different options like Sum, Count, Average, Min, Max,..... to summarize your table and required.