Subtotal Formula

Deepak Adhikary

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.

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!