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.
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