Share via

excel error "we can't summarize this field with SUM"

Anonymous
2023-11-28T17:05:23+00:00

Hello,

Does anyone have a solution to the problem below?

I'm trying to change the count column to sum, but it's giving the error:

excel error "we can't summarize this field with SUM"

Thanks

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-28T17:40:03+00:00

    The error message "we can't summarize this field with SUM" usually occurs when you try to use the SUM function on a field that contains non-numeric data. To resolve this issue, you need to ensure that the field you are trying to sum contains only numeric data.

    For Example, you can count test column, but you cannot change it to sum due to the column test only contains text.

    12 people found this answer helpful.
    0 comments