Simple I think

[Kelly Johns]

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/tutorial...e16-e93ab938dc36/web-services---soap--mu.aspx

 

[Dave Peterson]

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 here:
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.

 

[ryguy7272]

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

Also, check here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html#classic


HTH,
Ryan---

 

[ryguy7272]

You can achieve your goal with a Pivot Table. See this:
http://peltiertech.com/Excel/Pivots/pivottables.ht
http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/


HTH,
Ryan---