Spreadsheets

[Kelly Johns]

I am creating a spreadsheet, and would like to produce some statistics from it. How do i get data from two different columns one word one numeric.

I.e

Name Age Gender Initial/Review Mother attended
jahd 12 M Initial Y
jshh 14 F Review Y
kajd 13 M Initial N
kasl 12 M Review Y


I would like to know if the mother attended the initial reviews. What would the formula be?




EggHeadCafe - Software Developer Portal of Choice
C# Email With Attachment / Upload / Validation
http://www.eggheadcafe.com/tutorial...f2-59b545ced4fd/c--email-with-attachment.aspx

 

[Paul C]

in Excel 2007 you could use COUNTIFS and simply count the attended column if
it is Y and the Review Column is initial

=COUNTIFS(d110,"Initial",E1:e10,"Y")

you can also use a sumproduct formula (this will work in Excel 2003)

=sumproduct(--(D110)="Initial",--(E1:e10="Y"))

 

[ryguy7272]

This resource is great!
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
=SUMPRODUCT((C1:C10="M")*(D110="Initial"))

HTH,
Ryan---

 

[Rick Rothstein]

Unless I read the OP's post incorrectly, I think your formula should be
this...

=SUMPRODUCT((D110="Initial")*(E1:E10="Y"))