Sum of submissions last week

Lindsay Scarey

Hi there,

I want to create a formula that will return the sum of submissions in a column from the previous week (I want a static snapshot from the previous week, as opposed to a rolling 7-days).

I have a formula that is working for returning the sum of submissions from the previous month, and I tried modifying it to pull last week but I failed at that - the formula below is only pulling a single day and I need Monday-Friday.

=SUMIFS([FIMC Invoices Received]:[FIMC Invoices Received], Date:Date, WEEKDAY(@cell) = WEEKDAY(TODAY()) - 1, Date:Date, YEAR(@cell) = YEAR(TODAY()))

Thank you!

Kelly Moore

Hey @Lindsay Scarey

The function WEEKDAY lists days of the week. The function you need is WEEKNUMBER

=SUMIFS([FIMC Invoices Received]:[FIMC Invoices Received], Date:Date, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()) - 1, Date:Date, YEAR(@cell) = YEAR(TODAY()))

The WeekNumber function begins on Monday through Sunday.

Will this work for you?

Kelly

Kelly Moore

Hey @Lindsay Scarey

The function WEEKDAY lists days of the week. The function you need is WEEKNUMBER

=SUMIFS([FIMC Invoices Received]:[FIMC Invoices Received], Date:Date, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()) - 1, Date:Date, YEAR(@cell) = YEAR(TODAY()))

The WeekNumber function begins on Monday through Sunday.

Will this work for you?

Kelly

Lindsay Scarey

@Kelly Moore got it, thank you for the clarification! It's working now