Count value in colmn L based on Value in column J

[kvisaria]

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

 

[Vidar]

No problem, check out the COUNTIF function

 

[kvisaria]

I tried that but doesn't work.

 

[Vidar]

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

 

[kvisaria]

ADVERTISEMENT

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]

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]

ADVERTISEMENT

Rick

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

 

[Rick Rothstein]

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]

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]

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

Thanks for your help!!