I have a query regarding on SharePoint list. In the column heading, there is an option named "Totals" and under this "None or Count" drop-down is available. I have a "Status" column and I picked "Count" from the "Total". It shows the total count at the bottom of how many were planned/completed/canceled a trip under the "Status" column.

I have a calculated column named "Total Planned Days" It is the difference between "Planned Start Date" and "Planned End Date".

I used the below logic. Intentionally I used this formula.

=IF(AND([Planned End Date]>0,[Planned Start Date]>0),[Planned End Date]-[Planned Start Date]+1,"") 

But in the "Total Planned Days" calculated column the "Total" option is missing. The same thing is applied with "Total Actual Days" and there is also the missing "Total" option.

Is there any way to count the total at the bottom?

  • What is the returned type of your calculated "Total Planned Days" column, Number or Single line of text? Commented Aug 27, 2023 at 8:29
  • Number. Total difference
    – Nehad
    Commented Aug 27, 2023 at 8:31
  • Are you using modern (new) experience list in SharePoint online? Commented Aug 27, 2023 at 8:33
  • Yes, I am using the modern list
    – Nehad
    Commented Aug 27, 2023 at 8:34

1 Answer 1


Unfortunately, you cannot show "Totals" of SharePoint list calculated columns. This is a limitation of SharePoint calculated columns.

You can find more information and workarounds in below threads:

  1. Total of a calculated column on SharePoint 365 and MS Teams list
  2. How to add Total to calculated column in Sharepoint
  • 1
    Agree with Ganesh Sanap. And per my test, flow is a good workaround in the modern experience. Commented Aug 30, 2023 at 3:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.