# 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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### MrActuary

##### Board Regular
Code:
``=COUNTIF(C1:C6,">35")-COUNTIF(C1:C6,">40")``

#### Zack Barresse

##### MrExcel MVP
Or for multiple criteria ...

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

#### yankee428

##### Active Member
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.

#### CAW

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

#### yankee428

##### Active Member
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
4
Views
417
Replies
4
Views
91
Replies
2
Views
92
Replies
4
Views
133
Replies
14
Views
254

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,839
Messages
5,766,725
Members
425,374
Latest member
EgleA

### 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