What function will find and multiply specific values in excel?

P

paul/bones

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.
 
B

Barb Reinhardt

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))
 
P

paul/bones

Thanks Barb

Barb Reinhardt said:
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))
Click to expand...
 
Top