countif with condition

[Attila Fust]

I want to be able to count the values in a column if they
meet a condition in another cell. Essentially I want to
do the following:

Age Status
under s
under s
over s
under s
over s

I want to count the number of "s" in the Status column
where the value in the Age column is "under" (in this
example the count would be 3). Is this possible with the
countif function. If not, do I have another option?

Regards,

Attila

 

[JE McGimpsey]

one way:

=SUMPRODUCT(--(A1:A100="under"),--(B1:B100="s"))

 

[Bernard V Liengme]

Try this: =SUMPRODUCT( --(A2:A11="under),--(B2:B11="s"))
best wishes
Bernard

 

[Jason Morin]

=SUMPRODUCT(--(A2:A6="under"),--(B2:B6="s"))

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A100="under")*(B1:B100="s"))