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

EtgPara
Wed Jul 23 18:47:00 CDT 2008

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
>

tipsoftheweek
Wed Jul 23 23:33:00 CDT 2008

=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
> >