Cannot determine the needed formula
I am needing to get totals for a column based upon a date. I am tracking daily personnel stats (4 different Columns/options) via form submissions. I need a total daily numbers for each column. Can someone help me please.
Can this be accomplished with sheet summary or via a report. My brain is a bit fried.
Answers

Will your calculations be on the same sheet as the source data or a different sheet?
The basic formula that you would be using would end up looking something like this:
=SUMIFS([Column To Sum]:[Column To Sum], [Date Column]:[Date Column], @cell = DATE(2020, 03, 20))
There are numerous variables that can be built in that will allow greater flexibility to cut down on having to edit the actual formula, but that would depend on a number of things surrounding how your counts would be set up and how you intend to use the data.
EDIT: Corrected typo
Help Article Resources
Categories
Check out the Formula Handbook template!