What function will find and multiply specific values in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What function will find and multiply specific values in excel? 2
Counting text cells then multiplying by a value in another column 6
If cell contains a value, multiply... 3
Get rid of #VALUE, after multiplying 1
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
SUM 3
sumif and translate annual hours into weekly quarter hours 21
Need formula 3

Back
Top