What function will find and multiply specific values in excel?
I am using excel 2003.
I am trying to multiply 2 sets of data together for a project. However, I need to find all the corresponding values of one set for a single given value in another set. For example if the first water depth is 10 meters I need to find all the values in another column that are at 10m depth and multiply those values. |
What function will find and multiply specific values in excel?
Is it correct to assume you'er orignial post with the same title was a
different question? The only difference I can see is you want the values multiplied by each other insteda of by the instances of 10. Am I correct? "paul/bones" wrote: I am using excel 2003. I am trying to multiply 2 sets of data together for a project. However, I need to find all the corresponding values of one set for a single given value in another set. For example if the first water depth is 10 meters I need to find all the values in another column that are at 10m depth and multiply those values. |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com