# Count value in colmn L based on Value in column J

#### kvisaria

##### New Member
I need formula where I can count value in column L based on condition in column J.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### Vidar

##### Well-known Member
No problem, check out the COUNTIF function

#### kvisaria

##### New Member
I tried that but doesn't work.

#### Vidar

##### Well-known Member
It's easier to help you if you post examples of Your data With the result you want

#### kvisaria

##### New Member
It's easier to help you if you post examples of Your data With the result you want

Name Date Rate
A 5-Apr-12 12.933
B 9-Apr-12 0.903
C 9-Apr-12 0.909
D 11-Apr-12 4.037
E 13-Apr-12 2.052
F 13-Apr-12 2.057
G 13-Apr-12 2.05
A 13-Apr-12 2.047

I want count of Rate based on Name and date range. So for e.g. I want count of rate based on Name "A" and date between 5-Apr-12 thru 13-Apr-12

#### Rick Rothstein

##### MrExcel MVP
Name Date Rate
A 5-Apr-12 12.933
B 9-Apr-12 0.903
C 9-Apr-12 0.909
D 11-Apr-12 4.037
E 13-Apr-12 2.052
F 13-Apr-12 2.057
G 13-Apr-12 2.05
A 13-Apr-12 2.047

I want count of Rate based on Name and date range. So for e.g. I want count of rate based on Name "A" and date between 5-Apr-12 thru 13-Apr-12

Give this formula a try...

=COUNTIFS(A1:A9,"A",B1:B9,">="&DATE(2012,4,5),B1:B9,"<="&DATE(2012,4,13))

#### kvisaria

##### New Member
Rick

This works fine. But I want count of rate which is column C based on date range and name of "A"

#### Rick Rothstein

##### MrExcel MVP
Rick

This works fine. But I want count of rate which is column C based on date range and name of "A"

What do you mean by "count" of rate... an actual count of items (which is what I gave you) or a sum of the rates meeting the conditions. If the latter...

=SUMIFS(C1:C9,A1:A9,"A",B1:B9,">="&DATE(2012,4,5),B1:B9,"<="&DATE(2012,4,13))

#### kvisaria

##### New Member
I need the count of rate same as you have for SUMIFS. What you gave me was just count of items in A but I need count C based on A and Date range

#### kvisaria

##### New Member
when I try that formula with Countifs , I get error saying that I entered too few arguments.

Replies
0
Views
237
Replies
3
Views
97
Replies
2
Views
208
Replies
2
Views
212
Replies
0
Views
126

1,195,616
Messages
6,010,725
Members
441,565
Latest member
menangterus556

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