I have a spreadsheet that I need to do some miracle math for me.
There are three sheets in the workbook.
Sheet 1 is a dump from a web report. I can’t change the way it is laid out.
Sheet 2 and 3 are just explanations and billing values. I can move these all I want.
Here is what I need it to do:
Take the service in sheet 1 column C and determine the value found on the other sheet. For instance, Array Component = 60. Now take that value and multiply it by the count and output it in to column F. (Array Component * 3 = 180)
then I want to be able to add up the total number in one field (C1) and then do a divide by 60 in E1.
My skills in Excel are pretty lacking and I have not been able to get anywhere close. Any help would be GREATLY appreciated.
I have attached a sample report.
There are three sheets in the workbook.
Sheet 1 is a dump from a web report. I can’t change the way it is laid out.
Sheet 2 and 3 are just explanations and billing values. I can move these all I want.
Here is what I need it to do:
Take the service in sheet 1 column C and determine the value found on the other sheet. For instance, Array Component = 60. Now take that value and multiply it by the count and output it in to column F. (Array Component * 3 = 180)
then I want to be able to add up the total number in one field (C1) and then do a divide by 60 in E1.
My skills in Excel are pretty lacking and I have not been able to get anywhere close. Any help would be GREATLY appreciated.
I have attached a sample report.
Comment