Forum Discussion
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...
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.
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.