I have created a view for each of my projects in my time entry system. I want the SUM to add the hours for the hours in just the view. Currently, my formula returns all the hours in each view.
Hi Steve_Darlington,
Welcome to the Spreadsheet Community.
To resolve the above problem, make use of SUBTOTAL function above row header.
The formula (SUBTOTAL(9,E2:E)) which is highlighted in screenshot, will re-evaluate whenever we switch to different views created using Filter or Sort.
Additional information on setting row header and subtotal function is available at
2 Likes