How to create totals for different columns for a specific date range

Noemi Kecskes · 02/15/19

Hi

I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday.

My entries are created via webform.

I need to take into consideration the created date for my weekly time range

Could somebody help me please?

Thank you

Paul Newcome · 02/18/19

Try something along the lines of

=SUMIFS([Column to Sum]:[Column to Sum], Created:Created, WEEKNUMBER(@cell) = xxxxx)

You would just need to update the column names to reflect the correct columns, and enter your criteria in place of "xxxxx" whether it be an actual number (1 - 52) or referencing a cell ([Column Name]@row) or comparing to another date (WEEKNUMBER([Date Column]@row))

How to create totals for different columns for a specific date range

Comments

Help Article Resources

Categories