Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel multiply by different values based on quantity | Excel Discussion (Misc queries) | |||
how to write function to find max deviation from specific number . | Excel Worksheet Functions | |||
How to use FV function to find a payment to reach a specific goal | Excel Worksheet Functions | |||
How can i find specific values along a trendline? | Charts and Charting in Excel | |||
Lookup Function - Specific Values | Excel Worksheet Functions |