What should be selected to easily sum costs in a sorted data table based on changes in another column?

Selecting a subtotal is the most effective choice for easily summing costs in a sorted data table based on changes in another column. The subtotal feature allows you to create a summary of your data that totals values in a specific column following the changes in another column. For example, if you have a list of costs sorted by category, using the subtotal feature will enable you to automatically calculate the total costs for each category whenever the data changes.

This functionality is particularly useful in structured datasets where you need aggregate insights without manually summing each group of changes. It provides the flexibility to adjust the dataset and have the subtotals update accordingly, ensuring accuracy and saving time in data management.

While other options like Group By and Pivot Table can also aggregate data, subtotals are purpose-built for quick, straightforward summation in sorted lists, making them the ideal choice for this specific task.