Adding SUM to a view

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

1 Like