Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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...
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
