Sumifs issue or pivot issue... Help please

[excel_1317]

I have thousands of rows like below. I need to make a pivot for below data based on parent name. Now survey count in pivot shows as 48 which is wrong. If i do average, it gives me 7.4 and using max give me 10. But the correct survey count for ABC Corp. is 14(10+4). How can this be achieved in pivot, may be adding a helper column in the data? My solution is to bring 14 as survey count corresponding to ABC corp. in pivot. Excel masters please help

Parent Name	Survey id	Survey Count
ABC Corp	0123	10​
ABC Corp	0123	10​
ABC Corp
ABC Corp	0123	10​
ABC Corp	0456	4​
ABC Corp	0456	4​
ABC Corp	0456	4​
ABC Corp	0123	10​

 

[excel_1317]

Great!!!! Thanks a tonn!!