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

Hi,

 

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.

Comments

  • 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!

    Capture7.PNG

This discussion has been closed.