P AV
Initial/Review Did mother attend

Initial Y
Review N
Initial N
Review Y
Initial Y
Review N
Review Y
Initial N


I need to answer:

Did mother attend Initial: Yes/No
Did Mother attend Review: Yes/No

EggHeadCafe - Software Developer Portal of Choice
Web Services - SOAP / Multiple Recordsets
http://www.eggheadcafe.com/tutorials...-soap--mu.aspx

Use a formula like:

=sumproduct(--(a2:a10="initital"),--(b2:b10="y"))

Adjust the ranges to match--but you can't use whole columns (except in xl2007+).

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

=========
If you're using xl2007, look at =countifs() in excel's help.

Kelly, Johns wrote:

P AV
Initial/Review Did mother attend

Initial Y
Review N
Initial N
Review Y
Initial Y
Review N
Review Y
Initial N

I need to answer:

Did mother attend Initial: Yes/No
Did Mother attend Review: Yes/No

EggHeadCafe - Software Developer Portal of Choice
Web Services - SOAP / Multiple Recordsets
http://www.eggheadcafe.com/tutorials...-soap--mu.aspx

--

Dave Peterson

=SUMPRODUCT((A1:A10="Initial")*(B1:B10="Y"))

Also, check he
http://www.xldynamic.com/source/xld....T.html#classic


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Kelly Johns" wrote:

P AV
Initial/Review Did mother attend

Initial Y
Review N
Initial N
Review Y
Initial Y
Review N
Review Y
Initial N


I need to answer:

Did mother attend Initial: Yes/No
Did Mother attend Review: Yes/No

EggHeadCafe - Software Developer Portal of Choice
Web Services - SOAP / Multiple Recordsets
http://www.eggheadcafe.com/tutorials...-soap--mu.aspx
.

You can achieve your goal with a Pivot Table. See this:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Kelly Johns" wrote:

P AV
Initial/Review Did mother attend

Initial Y
Review N
Initial N
Review Y
Initial Y
Review N
Review Y
Initial N


I need to answer:

Did mother attend Initial: Yes/No
Did Mother attend Review: Yes/No

EggHeadCafe - Software Developer Portal of Choice
Web Services - SOAP / Multiple Recordsets
http://www.eggheadcafe.com/tutorials...-soap--mu.aspx
.