I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?