Formula to Sum by Current Week in Google Sheets

To sum by current week in Google Sheets, first, you should know how to filter dates that fall in the current week. Once you master this filter trick, you can play around with that.

From the filtered dates, you can perform different types of calculations like sum by current week, sum by weekdays, etc.

So what I am going to do is first providing you a formula that filters the current week’s dates or rows that containing the current week’s dates. Then I will explain to you how to sum by current week in Google Sheets.

Similar: Filter Data for Certain Number of Weeks in Google Sheets Using Formula

How to Filter Current Week in Google Sheets

Sample Data:

Filter Current Week in Google Sheets - Sample Data

In this dataset, I’ve highlighted the current week’s dates considering today’s date as of Sun, 17 Jun 2018.

If you follow my above dataset, please don’t stick with the dates in Column A. You should change that dates in column A, as the current week keeps changing as days go by.

I have considered the week starts from Sunday to Monday. If you want it from Monday to Sunday, you can adjust the formula that I am going to provide. I will explain that also.

The Formula to Filter Current Week’s Dates in Google Sheets

The following formula can filter the above-highlighted rows.

=filter(A3:C,weeknum(A3:A)=weeknum(today()))

The result would be the above-highlighted rows. If you want to start the weeks on Monday and end on Sunday, then tweak the formula as below.

=filter(A3:C,weeknum(A3:A,2)=weeknum(today(),2))

Here I’ve used the functions Filter, Weeknum and Today. Learn these functions in detail – Learn All the Popular Google Sheets Functions. Now let me tell you how to sum by current week.

Sum by Current Week in Google Sheets

The output of the above formula is as follows.

Formula output: Sum by Current Week in Google Sheets

Actually, for summing the column C amount based on the current week, column A and B values are not required in the filtered output.

But I’ve included the values in those columns for some reasons. In later if you want to conditionally sum current weeks data, this output will be useful.

If you just want to sum by current week, just change the above filter formula as below.

=filter(C3:C,weeknum(A3:A)=weeknum(today()))

Here the filter range A3:C has been changed to C3:C. So this filter formula will only return the values in Column C that falls in the current week.

Now you can just wrap this formula with the Sum and that’s the formula to sum by current Week in Google Sheets.

=sum(filter(C3:C,weeknum(A3:A)=weeknum(today())))

That’s all. Hope you have enjoyed the stay!

Related Google Sheets Tutorials:

  1. Find the Date or Date Range from Week Number in Google Sheets.
  2. How to Find Current Month’s Week Number In Google Sheets.
  3. How to Find Week Start Date and End Date in Google Sheets with Formula.
  4. Reset Week Number in Google Sheets Using Array or Non-Array Formulas.
Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

4 COMMENTS

  1. Hello,

    Thank you SO MUCH for this article!!!

    You say…

    The result would be the above-highlighted rows. If you want to start the weeks on Monday and end on Sunday, then tweak the formula as below.

    =filter(A3:C,weeknum(A3:A,2)=weeknum(today(),2))

    If I wanted to start the week on a Tuesday what would I need to change?

    I tried changing 2 to 3 but I got an error.

    Thank you for your help.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.