atferrari
Full Member level 4
- Joined
- Jun 29, 2004
- Messages
- 237
- Helped
- 7
- Reputation
- 14
- Reaction score
- 3
- Trophy points
- 1,298
- Location
- Buenos Aires - Argentina
- Activity points
- 1,996
I was asked to help a student with the basics of Excel. It's embarrasing but I couldn't solve this:
There is a list of 69 students, males and females, (M and F) of varying ages. I am asked to tell in a cell, the number of females older than 17.
I tried to use the function COUNT.IF, as follows:
=COUNT.IF(C2:C70;AND(E2:E70="F";D2
70>17))
range C2:C70 with the names (I expect the function to count over this range's cells)
range D2: D70 with the ages
range E2:E70 with F or M
Please note that I tried to translate the functions that in Spanish show up as (longtime I don't use an English version of Excel):
CONTAR.SI (conditional counting)
Y (direct equivalent of a boolean AND)
What I am doing wrong?
The usual (useless) disclaimer "I used to be profficient in this..." also applies....
There is a list of 69 students, males and females, (M and F) of varying ages. I am asked to tell in a cell, the number of females older than 17.
I tried to use the function COUNT.IF, as follows:
=COUNT.IF(C2:C70;AND(E2:E70="F";D2
70>17))range C2:C70 with the names (I expect the function to count over this range's cells)
range D2: D70 with the ages
range E2:E70 with F or M
Please note that I tried to translate the functions that in Spanish show up as (longtime I don't use an English version of Excel):
CONTAR.SI (conditional counting)
Y (direct equivalent of a boolean AND)
What I am doing wrong?
The usual (useless) disclaimer "I used to be profficient in this..." also applies....