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
Comments
-
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.