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

Noemi Kecskes

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

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))