Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries.
=SUMIF(Task2:Task4, Task5, Hours2:Hours4)
New Webform entry is line 5, Formula will not automatically capture that added line.
Objective is that based on the task name to obtain a total number of hours worked (in a massive list of data) - that is then linked back to a project summary as a total hours worked cell.
Help Article Resources
Check out the Formula Handbook template!