CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN
 

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

CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN
 

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

"Etg-Para" wrote:

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

CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA I
 

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

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Etg-Para" wrote:

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

"Etg-Para" wrote:

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