Need help with formula

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

Guest

How do I write a formula that will search a worksheet tab for names in a
particular column (in this case A), pull all corresponding values for each
hit from another column (in this case D), and give me the sum of all values
from column D on a different tab. The tab with all of the raw data may
contain a few hundred entries at any given time so I need the formula to
accommodate for that.

I have used the "COUNTA" and "COUNTIF" formulas to search for values in the
past, but now I need to perform the search and give me the values from a
different column.

Any help would be greatly appreciated.
 
You must log in or register to reply here.

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

Help with formula 7
Trailing 30 days sum calculation with excel 1
Excel Help to copy information from one row at a time to another sheet 1
Help needed 0
Filtering with SUMIFS 1
Excel Need Countifs Formula Help 0
Summing cells based on mulitiple criteria over mulitple columns 1
need help with formula 7

Back
Top