• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to deduce quantity within a precise month only, and from the beginning of the year to a precise month

Pasadu

Member
Dear Sir, Please help me with a formula that could help me know the number of containers loaded in Jan only, Feb only, March only, for all the agencies and the number of containers loaded by these same agencies within Jan-Feb, Jan-Mar, Jan-Apr, Jan-May, Jan-June, etc. Please bear in mind that the list will keep on being updated, so the reflections must happen when the sheet is updated. I have attache the file. Thank You.
 

Attachments

  • Analysis.xlsx
    13.3 KB · Views: 2
  • Personal analysis.png
    Personal analysis.png
    81.7 KB · Views: 2
You can build a pivot table to do the individual months by company by month. Not sure how to do the cumulatives. Attached is your file demonstrating the PT solution.
 

Attachments

  • Analysis.xlsx
    23.3 KB · Views: 3
Back
Top