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.

 

[Rick Rothstein]

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

The SUMIFS formula I gave you is based on Column A and the date range (based on the Dates in Column B).

 

[kvisaria]

Instead of sum and I need count of rate. Can you please let me know how I do that

 

[Rick Rothstein]

Instead of sum and I need count of rate. Can you please let me know how I do that

The formula I gave you in Message #6 did that, but you said the answer was wrong. I think you should give us an example with more "hits" within the range you specify along with several not within the range and then tell us the value you want returned for those example values... then we will know the "target" our formulas have to return. Right now, you and I seem to be dancing around terminology issues whereas, as they say, a "picture" would be worth a thousand words.

 

[kvisaria]

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.00

Above is the example. I need to know count of rate based on Name and date range. so For example, =Countifs(C1:C9,A1:A9,"A",B1:B9,">="&DATE(2012,4,5),B1:B9,"<="&DATE(2012,4,13)) where I will get the count of C which is rate but when I typed in this formula, I get the error saying that "too few arguments".
I hope this clarifies. I appreciate your help!!

 

[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.00

Above is the example. I need to know count of rate based on Name and date range. so For example, =Countifs(C1:C9,A1:A9,"A",B1:B9,">="&DATE(2012,4,5),B1:B9,"<="&DATE(2012,4,13)) where I will get the count of C which is rate but when I typed in this formula, I get the error saying that "too few arguments".
I hope this clarifies. I appreciate your help!!

I see the problem... you changed the formula I posted originally and that change made it not work correctly. The part you added is shown in red above. This is the formula that I posted...

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

 

[kvisaria]

I changed it because your formula doesn't give me count of C1:C9 which is rate so how do I do that

 

[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.00

Above is the example. I need to know count of rate based on Name and date range. so For example, =Countifs(C1:C9,A1:A9,"A",B1:B9,">="&DATE(2012,4,5),B1:B9,"<="&DATE(2012,4,13)) where I will get the count of C which is rate but when I typed in this formula, I get the error saying that "too few arguments".
I hope this clarifies. I appreciate your help!!

You not answer this part of the question that I posted in Message #13...

"and then tell us the value you want returned for those example values... then we will know the "target" our formulas have to return"

So, what value is the formula supposed to return for the above data?

 

[kvisaria]

Count of Rate. for example, name is "A", and date range is "5-apr-12 thru 13-apr-12, then count of rate should be 2 which is what I need