CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN

E

Etg-Para

I am trying to take data from multiple columns in one worksheet on the same
Excel workbook, and based on the results meeting certain criteria, sum the
data in another column from the same worksheet into a table field in another
workbook.

For example, I have the following columns with multiple fields of data in
each:

Name Type Topic Hours

I want to create a formula to sum all of the hours if the Name is Joann, the
Type is Easy, and the Topic is Mystery.

Can someone help me?

Thanks in advance.

Etg
 
E

Etg-Para

Sorry, all I forgot to mention that I am working in Excel 2003. Thank you
again. Etg
 
M

M Kan

=sumproduct(--(range_of_names="Joann"),--(range_of_type="Easy"),--(range_of_topics="Mystery"),range_of_hours)
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Count rows based on multiple criteria 3
Multiple Criteria Sum 8
SUMIFS, one criteria range, multiple criteria 3
SUM formula help PLEASE??? 4
Extract multiple results based on multiple criteria 4
Summing cells based on mulitiple criteria over mulitple columns 0
MULTIPLE CRITERIA RETURNING SUM OF RESULTS 5

Top