If you love low-code solutions then sum data per week using a pivot table is the way to go.

The only trick here is to remember, Pivot tables lack the Week grouping.

A way around this issue is to group 7 days together.

See the below Video for steps to follow:

DOWNLOAD WORKBOOK

Print Friendly, PDF & Email

Do you want to excel in Excel?

Or

Seeking Microsoft Certification?

Every Week Receive Resources To Get you Closer to Your Goal!

No Huff! No Fluff! No Spam!

You are on your way to Excelling in Excel and Becoming Microsoft Certified!

Share This

Spread the Good News!

Do me favour, please? Share this with your friends!

Thanks For Commenting!

Awesome for you to comment! Please share the post with your friends.