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

Abdu Albur
✭✭
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:
Comments
-
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
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives