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

✭✭✭✭✭
edited 12/09/19

Hi,

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.

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

Regards

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!
Tags:

• ✭✭✭✭✭✭

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.

Craig

This discussion has been closed.