Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Subtotal Formula



I want to take the subtotal of the rows, after applying filter. in excel I was using =subtotal(9, C2:C100), where C2 to C100 are the data field.


I tried to apply the same forumula but not working on smartsheet.


Is there a way to calculate subtoal of the filtered rows? Please guide.


  • Greg Gates
    Greg Gates ✭✭✭✭✭

    Unfortunately, there doesn't seem to be a function that's analogus to Excel's "Subtotal." That being said, you could do a "SUMIF" based on whatever criteria you're using to filter. For example, if my sheet looks like this:


    You could write a SUMIF formula to calculate the "subtotal":

    =SUMIF([Text Column 2]1:[Text Column 2]10, "Show", [Primary Column]1:[Primary Column]10)


    I hope that's helpful!


This discussion has been closed.