Counting between date range

[WannaBeExcelGeek]

Hello all,

Have data similar to


abc 5/27/2008

abc 1/26/2010

abc 5/27/2008


My question is how do I count the number of times "abc" apears between date range 10/1/2011 - 11/1/2011 without hard coding the date. I currently have this formula


=COUNTIFS(dcv!A:A,"ABC",dcv!V:V,">=10/1/2011",dcv!V:V,"<11/01/2011")


Thanks for your help. Oh and the raw data is on sheet "dcv" if that helps.....

 

[Luke M]

If you're not hard coding the date, I'm assuming you have them in cells somewhere? I'll assume C2 and C3

=COUNTIFS(dcv!A:A,"ABC",dcv!V:V,">="&C2,dcv!V:V,"<"&C3)

 

[fred]

Thanks, Luke M. I didn't realize I could use "&". now countifs is more versatile than I thought!

 

[Luke M]

You're welcome, Fred. =)

 

[WannaBeExcelGeek]

Luke M. Thank you! It worked and I also didn't know you could use & in that manner. Again thanks for your help.

 

[WannaBeExcelGeek]

Luke M.

Can you clerify the "&"

=COUNTIFS(dcv!A:A,"ABC",dcv!V:V,">=10/1/2011",dcv!V:V,"<11/01/2011")


=COUNTIFS(dcv!A:A,"ABC",dcv!V:V,">="&C2,dcv!V:V,"<"&C3)


Comparing the two I see you place the " on the greater than/equal and the & before the cell with the date. Why?

Hope this make sense.

 

[vijaySharma]

Its because you did not want to hard code the dates, now you simply have to change the dates in the cells C2 and C3 for anothere date range.


~VijaySharma