| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating function to insert data based on criteria | Excel Worksheet Functions | |||
| how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
| Creating Array formulas with multiple criteria | Excel Worksheet Functions | |||
| creating a function with multiple criteria | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Linear Mode
