Hi,
I’m working for a small company, and have been using excel daily for a couple of years. We want our reports to become more automated, and stop using time punching in hours and results to calculate our daily earnings. I have two separate data sources that I use in our daily production. One calculates how many hours we use per project and the other shows the result per project. I use excel to blend these numbers to show statistics on campaigns, agents and revenue. In order to take my report further, I want to be able to copy/paste in the data from our data sources, and have the excel-sheet automatically gather the relevant data and summarize it per campaign and agent. I have tried playing around with vlookup and IF formulas, but I can’t seem to crack the code.
I have attached a very simplified data set, that shows test numbers for both hours per campaign and results per campaign. The clue is to find a formula or function that would calculate the hours for the two different projects from the first data source, and calculate the results from the second data source.
I am very grateful for any contributions. Please let me know if any further explanation is needed.
- Philbert :hat:
I’m working for a small company, and have been using excel daily for a couple of years. We want our reports to become more automated, and stop using time punching in hours and results to calculate our daily earnings. I have two separate data sources that I use in our daily production. One calculates how many hours we use per project and the other shows the result per project. I use excel to blend these numbers to show statistics on campaigns, agents and revenue. In order to take my report further, I want to be able to copy/paste in the data from our data sources, and have the excel-sheet automatically gather the relevant data and summarize it per campaign and agent. I have tried playing around with vlookup and IF formulas, but I can’t seem to crack the code.
I have attached a very simplified data set, that shows test numbers for both hours per campaign and results per campaign. The clue is to find a formula or function that would calculate the hours for the two different projects from the first data source, and calculate the results from the second data source.
I am very grateful for any contributions. Please let me know if any further explanation is needed.
- Philbert :hat: