• 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.

Use VBA to Add Values Based on Multiple Criterias

Sanzay Kumar

New Member
Hello,
I was wondering if the following can be done. Basically, I need to extract a summary from a data set (I have attached an example) into a separate sheet so I can export easily as a report.

The summary should add up the hours based on location, date and service. Some of the services are to be combined, in the example, you will notice that the hours for Domestic RRD and CTL RRD are added together for the same location and date.

Any help would be appreciated!
Thank you!
 

Attachments

  • example.xlsx
    9.8 KB · Views: 5
Sanzay Kumar
Are only those (Domestic RRD and CTL RRD) added together or
would be there 'some' more possible combinations?

Have You thought to use Pivot-table? (Layout would be a little different.)
 
Cross-posted here:
https://www.mrexcel.com/forum/excel...-vba-add-values-based-multiple-criterias.html
https://www.excelforum.com/excel-pr...o-add-values-based-on-multiple-criterias.html
http://club.futureinhands.com/Threa...vba-to-add-values-based-on-multiple-criterias
https://www.ozgrid.com/forum/forum/...vba-to-add-values-based-on-multiple-criterias

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread. This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Back
Top