# COUNTIF?

#### CAW

##### Board Regular
I have a column of data that I want to tally different age ranges from.

The first range checked uses this formula:
Code:
``=COUNTIF(\$D\$2:\$D\$41,"<35")``
How do I check each range after that when the criteria is >35 & <40, >40 & <44, etc.....?

Thanks.

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Code:
``=COUNTIF(C1:C6,">35")-COUNTIF(C1:C6,">40")``

Or for multiple criteria ...

=SUMPRODUCT(--(Range1=Criteria1),--(Range2=Criteria2))

you could use something like this

=SUM((rng>35)*(rng<40)+(rng>40)*(rng<44))

where you name your range rng. this is an array formula and must be entered using ctrl+shift+enter. notice that * equates to AND, and + equates to OR. be carefull not to overlap or your will doublecount some items.

Thanks for all the help guys! You resolved my issue! ray:

Thanks Firefytr,

I'm sold on sumproduct() after doing some research on it. No more building array formulas using sum()

For anyone interested, here is a great article on this function and why they use -- in the formula. http://xldynamic.com/source/xld.SUMPRODUCT.html

Replies
6
Views
286
Replies
7
Views
155
Replies
2
Views
172
Replies
9
Views
264
Replies
7
Views
285

1,221,522
Messages
6,160,308
Members
451,637
Latest member
hvp2262

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back