Return data from multiple cells

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

Guest

How do I get a return of data that finds all cells in a column that meet
criterior A then meet criterior B in a different column on the same row and
then return a total value of the sum of all cells in another column.
 
Use Sumproduct()

For instructions, check this link:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do I get a return of data that finds all cells in a column that meet
criterior A then meet criterior B in a different column on the same row and
then return a total value of the sum of all cells in another column.
 
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

Array Formula Help Needed 5
Hide columns based on row values 2
Returning Multiple Results with Vlookup 1
What formula do I use to show the last cell with text in a colum 3
Combining text from multiple cells 6
Returning multiple instances of the same lookup value 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1

Back
Top