SUMIF formula within last 7 days

angelapaj

Hi,

I need help with one of my formulas. I have an hours repository sheet where all employees log their hours. They include their names, week of (first Monday of each week) + number of hours spent on each project.

I am now creating a separate sheet where I need to pull the number of hours logged by each employee in the last 7 days. I keep getting the INVALID OPERATION error with my formula.

=SUMIFS({No of hours spent}, {Name}, =[Full Name]@row, AND({Week of} > TODAY(-8), {Week of} < TODAY(+1)))

Can you please help?

Linda Manduchova

Hi @angelapaj -

This should solve it:

=SUMIFS({No of hours spent},{Name}, [Full Name]@row, {Week of}, AND(@cell > TODAY(-8), @cell <= TODAY()))

Linda