How do combine different names under one header & use sumif to see their performance.
for eg
I have client names in column A & Values in Column B
ajay 24
Ashish 34
Keith 234
John 123
Peter 435
Paul 34
Mark 3456
Andrew 46
want to add Ajay & John & Mark under a single header called dealer & see their sum total
Bookmarks