LinkBack URL
About LinkBacks
I have a list of daily data and want to summarise by month and year, how can i do this?
summarise by month
I have a list of daily data and want to summarise by month and year, how can i do this?
Hi angel1 and welcome to the forum.
To summarize your data by month and year can be dome using formulas such as:
SUM, SUMIF, SUMIFFS, COUNT, COUNTIF, COUNTIFS, SUMPORDUCT, AVERAGE, AVERAGEIF and few more.
If you have a question, I would suggest to upload a sample workbook with your data and we will try to figure out the best solution to your problem.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thankyou for your reply AlKey! i'm not sure how to upload my workbook? :/
Depends on the nature of the data. If you were able to attach a sample or just create one, the picture would be clearer.
Assuming you have dates associates with whatever your're summarizing, you could use SUMIF(S) or SUMPRODUCT.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
On the bottom of your screen click on Go Advanced the click on a paperclip on the toolbar. Click Add Files, select file, upload and Done.
should be attached nowthank you!
Please see attached file.
Amazing!! thank you so much :D Can you describe how you did it please?...i would like to be able to replicate this myself
Thank you, I glad it worked for you. I simply used Excel Pivot table feature which is most suitable in this type of situations.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks