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
