Need to sum and transpose the data from about 1600 rows. This is a ledger that was pulled from Quickbooks. I have done several examples to guide you. The following instructions use rows 15 to 25 as an example. There are about 130 groups of data (the example set of rows 15 to 25 is one group), each group is identified by the label in column B. We will need to use the data in columns B through J to populate the summary in columns L through R. So with the data from rows 15 through 25 and columns B through J, this is how each of the result rows L through R should be completed:
Column L: Is the date of the "show" which should be the common denominator per column G in the data group.
Column M: is the label of the data group, which is in column B
Column N: is the sum of column J when column H indicates "Musicos" for the data group
Column O: is the sum of column J when column H indicates "Tecnicos" for the data group
Column P: is the sum of column J when column H indicates "Renta equipos" or "Equipos" for the data group
Column Q: is the sum of column J when column H indicates "Comision" for the data group
Column R: is the sum of column J when column H indicates "DJ" for the data group
Column S: is the sum of column J when column H indicates anything else other than the above for the data group
THANKS !
Hello,
I have experience in excel, data entry.
I have completed this type of work with 100% accuracy.
Please check my portfolio.
I can do this project.
I am ready to start Now.
Please review my bid.
Thanks.
Rich
i had good experience in Excel like migration and other stuffs.
i had good experience in Excel like migration and other stuffs.
i had good experience in Excel like migration and other stuffs.
i had good experience in Excel like migration and other stuffs.
Good Day Sir/Madame, i can assure you in as much as 7 days or less i can deliver you the project. I am fluent in excel and other microsoft office application.
Thank you for considering me.
God Bless and more power!
Hi~First of all let me introduce myself.
I had worked with MNC company pass 6 years and i trained up a good skill in excel and ms word due to work requirement.
I can complete your project in fast if you hire me.
I am ready to start working on your job today.