I'm a bit of a newbie to Google Sheets formulas and such.

I have a set of data entered daily with the dates converted by WEEKNUM() to display and allow me to filter by week no. I want to add the values for a number of entries by the resultant week no. to obtain a weekly total for different columns.

enter image description here
(Click image to enlarge)


If column B has week number and columns E,F,G,H,I,J have quantities for which you need weekly totals, then query returns the relevant totals:

=query(B:J, "select B, sum(E), sum(F), sum(G), sum(H), sum(I), sum(J) group by B")

Alternatively, you can create a pivot table report.

  • Thanks, that has been a great help. I greatly appreciate the help.
    – Dave
    Apr 22 '16 at 12:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.