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.

adding numbers

Options
Abdu Albur
Abdu Albur ✭
edited 12/09/19 in Archived 2015 Posts

hi

when there is a sheet with , for example, 100 records...rows. and one of the columns is numeric,

when I filter the column and sum the numbers the application add all the records not the filtered ones...

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Bobby Andres
    Bobby Andres ✭
    Options

    Filtering isnt going to change any data in your sheet, including your formulas. Filters will not change the range in your formulas, which is why they are not only counting filtered rows.

     

    You can use a SUMIF formula to only sum the rows that meet your criteria which would act just like calculating on a filtered view

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories