By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Need help with Excel formulas.

P: 2
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.
Attached Files
File Type: zip Sample_Report.zip (26.2 KB, 52 views)
Sep 24 '10 #1
Share this Question
Share on Google+
1 Reply


P: 2
Bump - No replies yet... :-(
Sep 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.