Hi,
I believe I need a SUMPRODUCT function to achieve this arithmetic. I never had to do this computation before so now im curious...
I have percentages of hours worked on a machine in one column. Then the MAX hours of the machine is one cell. Thus, if a data point = 50% and max hours = 10, then the result would be 5. I need to sum these results for a final value without adding helper columns.
I have attached an example of my workbook.
Thanks for the help!
Why do you think you need SUMPRODUCT ?
This is simply
=SUM(E9:E15)*E6
isn't it?
Last edited by Special-K; 01-18-2018 at 12:07 PM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Is this it???
=SUM(E9:E15)*E6
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
All,
It appears that is correct! I hadn't realize that would work.
Thanks for your help
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks