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 by the number of 10m depth measurements. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function will find and multiply specific values in excel?
Let's say that you have your water depth in A1:A10 and your "other data" is
in B1:B10. Try this =Sumproduct(--(A1:A10=10),(B1:B10)) "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 by the number of 10m depth measurements. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What function will find and multiply specific values in excel?
Thanks Barb
"Barb Reinhardt" wrote: Let's say that you have your water depth in A1:A10 and your "other data" is in B1:B10. Try this =Sumproduct(--(A1:A10=10),(B1:B10)) "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 by the number of 10m depth measurements. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What function will find and multiply specific values in excel? | Excel Worksheet Functions | |||
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 |