Forum Discussion

Copper Contributor

Dec 03, 2023

THUNKS

http://www.myonlinetraininghub.com/excel-formulas-to-summarise-monthly-data-into-quarters Above is the link to reference article about which I have some questions that I am posting below. SumQtr...

SumQtrsSergei.xlsx69 KB

SumQtrsPeter.xlsx33 KB

Formulas and Functions

peiyezhu

Bronze Contributor

Dec 04, 2023

https://www.myonlinetraininghu.....o-quarters/
I can not open the url you provided.

If anyone wants then I can send them over the email.
Can you share it here or some cloud storage like 1drv?

VijayVardhan
Copper Contributor
Dec 04, 2023
I have attached the files and I have added each step in the sheets that unfold the formulas one by one to get the hang of it.
- peiyezhu
  Bronze Contributor
  Dec 04, 2023
  VijayVardhan
  
  Thanks for your response.
  I am afraid I can not provide more information because LAMBDA only available on o365 PC version but I have no PC on hand.
  
  I guess if you transpose the raw data layout from multiple columns to multiple raws as :
  
  date item quantity
  .
  
  You can sum them by pivottable or sql group by quarter.
PeterBartholomew1
Silver Contributor
Dec 04, 2023
peiyezhu
I believe the url I provided is the correct version of the one intended by the OP. The files can then be downloaded from links within Mynda 's blog.
- peiyezhu
  Bronze Contributor
  Dec 04, 2023
  I see.
  Thanks.