A
atferrari
I was asked to help a student with the basics of Excel. It's embarrasin
but I couldn't properly solve this:
Having 69 students, males and females, (M and F) of varying ages, I a
asked to calculate in a cell the number of females older than 17.
I tried to use the function COUNTIF, as follows:
=COUNTIF(C2:C70;AND(E2:E70="F";D2
70>17))
range C2:C70 with the names (I expect the function to count over thi
range's cells
range D270 with the ages
range E2:E70 with *F* or *M*
What I am doing wrong? (Using ranges instead of single cell, perhaps?
I know it can be done with a matrix (product) but not at the level o
this student who is just starting with Excel
The only way I found is testing one of the ranges to get TRUE/FALSE i
a column and the applying COUNTIF to THAT column
Do you know something more elegant and practical
Yes, I know Excel 2007 has COUNTIFS but I use 2003
but I couldn't properly solve this:
Having 69 students, males and females, (M and F) of varying ages, I a
asked to calculate in a cell the number of females older than 17.
I tried to use the function COUNTIF, as follows:
=COUNTIF(C2:C70;AND(E2:E70="F";D2
70>17))range C2:C70 with the names (I expect the function to count over thi
range's cells
range D2
70 with the agesrange E2:E70 with *F* or *M*
What I am doing wrong? (Using ranges instead of single cell, perhaps?
I know it can be done with a matrix (product) but not at the level o
this student who is just starting with Excel
The only way I found is testing one of the ranges to get TRUE/FALSE i
a column and the applying COUNTIF to THAT column
Do you know something more elegant and practical
Yes, I know Excel 2007 has COUNTIFS but I use 2003