Multiple criteria for countif

  • Thread starter Thread starter Dewald
  • Start date Start date
D

Dewald

Hi
I am sitting with a spread that i need to count the number
of people that are between the ages of 29 and 40. i tried
using the countif, but i seem to have done something wrong.

Please give me some ideas
Thanks
 
Try something like

=COUNTIF(A1:A10,"<=40")-COUNTIF(A1:A10,"<29")
 
Using countif you can do

+COUNTIF(A1:A200,">=29")-COUNTIF(A1:A200,">=40")
 
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

Excel Need Countifs Formula Help 0
countif criteria sg 7
countifs Function not giving desired result with date criteria 2
COUNTIF PROBLEM 6
COUNTIF multiple criteria 2
Count multiple criteria 7
using COUNTIF I want to count multiple values 2
countifs with multiple dates 2

Back
Top