Cannot determine the needed formula

Angela

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.

Paul Newcome

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