What function will find and multiply specific values in excel?

[Guest]

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.

 

[Guest]

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?