countif with condition

  • Thread starter Thread starter Attila Fust
  • Start date Start date
A

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
 
Try this: =SUMPRODUCT( --(A2:A11="under),--(B2:B11="s"))
best wishes
Bernard
 
=SUMPRODUCT(--(A2:A6="under"),--(B2:B6="s"))

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

complex CountIf situation 3
countif 3
countifs 23
CountIf with And 0
Countif and Right functions 8
Formula (or code) return the largest number of duplicates in a list. 16
countifs Function not giving desired result with date criteria 2
Excel Need Countifs Formula Help 0

Back
Top