Hello Dear community,
I have 2 years sales data , which I need to calculate sum for each week.
I used weekday function,
so from B2:ZR2 I have weekdays. (Monday Tuesday Wednesday Thursday Friday Saturday Sunday)
from B10:ZR68 I have values.
A10:A68 Product names.
How can I get sum of each week? Please help
I have 2 years sales data , which I need to calculate sum for each week.
I used weekday function,
so from B2:ZR2 I have weekdays. (Monday Tuesday Wednesday Thursday Friday Saturday Sunday)
from B10:ZR68 I have values.
A10:A68 Product names.
How can I get sum of each week? Please help