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.

Formula to include a specific range and all new entries

J Tech
J Tech ✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts


I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries.

Can you please help me?

=SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)


J Tech

If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    The easiest way is to count the entire column and subtract the rows you are not interested in (rows 1-5)

    =SUMIF([1 - BT]:[1 - BT], "KS", [1 - # of BT]:[1 - # of BT]) - SUMIF([1 - BT]1:[1 - BT]5, "KS", [1 - # of BT]1:[1 - # of BT]5)

    There are other ways, but this is by far the easiest.

    I hope this helps.


This discussion has been closed.