Spreadsheets
 

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/tutorials...ttachment.aspx

Spreadsheets
 

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

=COUNTIFS(d1:D10,"Initial",E1:e10,"Y")

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

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

--
If this helps, please remember to click yes.


"Kelly Johns" wrote:

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/tutorials...ttachment.aspx
.

Spreadsheets
 

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

HTH,
Ryan---

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


"Paul C" wrote:

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

=COUNTIFS(d1:D10,"Initial",E1:e10,"Y")

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

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

--
If this helps, please remember to click yes.


"Kelly Johns" wrote:

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/tutorials...ttachment.aspx
.

Spreadsheets
 

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

=SUMPRODUCT((D1:D10="Initial")*(E1:E10="Y"))

--
Rick (MVP - Excel)


"ryguy7272" wrote in message
...
This resource is great!
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
=SUMPRODUCT((C1:C10="M")*(D1:D10="Initial"))

HTH,
Ryan---

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


"Paul C" wrote:

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

=COUNTIFS(d1:D10,"Initial",E1:e10,"Y")

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

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

--
If this helps, please remember to click yes.


"Kelly Johns" wrote:

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/tutorials...ttachment.aspx
.