Hello.
I have a spreadsheet of about 300 rows, with a total at the bottom to sum two number columns. (I have 5 data columns and two amount columns.) I am sorting on a data column which removes more than half of my rows. I want to see the totals at the bottom update with only the remaining rows, but it does not update. The total remains the same number total for all 300 rows. I have another spreadsheet where this works, but I cannot figure out what is different.
Thanks for any help!
I have a spreadsheet of about 300 rows, with a total at the bottom to sum two number columns. (I have 5 data columns and two amount columns.) I am sorting on a data column which removes more than half of my rows. I want to see the totals at the bottom update with only the remaining rows, but it does not update. The total remains the same number total for all 300 rows. I have another spreadsheet where this works, but I cannot figure out what is different.
Thanks for any help!
