Count value in colmn L based on Value in column J

kvisaria

New Member
Joined
Jun 27, 2007
Messages
27
I need formula where I can count value in column L based on condition in column J.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
It's easier to help you if you post examples of Your data With the result you want
 
Upvote 0
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
 
Upvote 0
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))
 
Upvote 0
Rick

This works fine. But I want count of rate which is column C based on date range and name of "A"
 
Upvote 0
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))
 
Upvote 0
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
 
Upvote 0
when I try that formula with Countifs , I get error saying that I entered too few arguments.

Thanks for your help!!
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top