If then formulas - do they exist?

[modano9]

I'm trying to count the number of people in an age group, but only if another column is marked yes. Can anyone help me?

I thought I remembered somekind of if, then type of formula way back from my computer class days, but it's not working. Here's an example of what I thought it would be like...

If (E2:E50, "y"), then countif (F2:F50, ">18")

Any help would be appreciated!

Thanks!

 

[just_jon]

I'm trying to count the number of people in an age group, but only if another column is marked yes. Can anyone help me?

I thought I remembered somekind of if, then type of formula way back from my computer class days, but it's not working. Here's an example of what I thought it would be like...

If (E2:E50, "y"), then countif (F2:F50, ">18")

Any help would be appreciated!

Thanks!

Try --

=SUMPRODUCT((E2:E50="y")*(F2:F50>18))

or even better --

=SUMPRODUCT(--(E2:E50="y"),--(F2:F50>18))

 

[santeria]

Look up the parameters for the IF formula in the F1 help file.

You can construct something that will look for what you want to do.
It works exactly like an IF - Then Logical Formula.



Ooops, and someone beat me to the best option

 

[Aladin Akyurek]

Must each cell in E2:E50 house a "y" or a single "y" anywhere in E2:E50 is sufficient for applying CountIf?

 

[modano9]

just_jon,
I tried both your formulas, but they both continue to tell me there's an error, any suggestions?

Aladin,
each cell will either contain a Y or a N.

Thanks y'all!

 

[just_jon]

What does the below return --

=ISNUMBER(F2)

 

[modano9]

Don't know what you mean

 

[just_jon]

How about --

=SUMPRODUCT(--(E2:E50="y"),--(F2:F50>"18"))

what error are you getting? the =ISNUMBER bit is a test to see if column F contains true numbers, or text that happens to look like numbers.

 

[Yogi Anand]

Chances are your entries in column F are text entries -- so how about if you try ...

=SUMPRODUCT((E2:E50="y")*(--(F2:F50)>18))

 

[Aladin Akyurek]

...each cell will either contain a Y or a N...

I believe I didn't get all the answers! Are you trying to count ages above 18 in one column whenever a "y" in the other column? If so, you are already given the formula you need.

=SUMPRODUCT(--(E2:E50="y"),--(F2:F50>18))

If not, please try to make explicit what you exactly want to count?