Count occurrences of value in a date range I can specify easily each time

Hi folks, I've been searching and have found similar threads for answers but can't seem to get anything working myself. I'm hoping someone can help.

Column A is date mm/dd/yyyy
Column B is general format and is based off a calculated formula. Values look like "12/3" and "19/1", etc.

I'd like to find the number of occurrences of a value specified in a given date range. For example, how many 12/3's are there from 1/1/1900 - 12/31/1901.

I can do this with this formula where B4 is 12/3, and the range of of rows B4-B369 in this case is one year, =COUNTIF($B$4:$B$369,B4)

However I need the date to be dynamic as well as to be able to enter in whatever I want for the value. Ideally, I'll have A1 reserved to enter in a start date, A2 an end date, and B1 an entry for the value.

Thanks in advance -
Mika

=COUNTIFS will allow you to include multiple criteria. Just create cells for your start and end dates, then add criteria that the cells be between your start dates (e.g., $B$4:$B$369>start_date_cell,$B$4:$B$369<end_date_cell)

=count(if(($A:$A<=c1)*($B:$B<=d1),Row($A:$A)))

put date in the a1 ..
And required no. In d1
use ctrl shift enter to enter the formula..

Say thanks, click *

So I have
A1 start date
A2 end date
B1 entry where I type in 12/3
B2 where I put the following formula which is supposed to display the count
=COUNTIF($B$4:$B$369,B1)>$A$1,$B$4:$B$369<$A$2)

However I'm getting an error. (I apologize for my noobieness..)

=count(if(($A:$A>=a1)*($A:$A<=a2)*($B:$B<=B1),Row($A:$A)))

hey man replace the $A:$A with your date range... And $B:$B with your no. Range..

Use ctrl shift enter to enter the formula...

Hi Vikas - it's close but not quite. I'm keeping my range to one year for now to make sure results are accurate. My date range is in A3-A368. So here is the full formula:

=COUNT(IF(($A$3:$A$368<=A1)*($A$3:$A$368<=A2)*($B$3:$B$368<=B1),ROW($A3:$A368)))

And of course I'm using ctrl+sft+enter and seeing the {} surrounding. It's giveng me a result of 1 when it should be 4.

Okay do you want to include both dates if no then remove the = signs in both conditions....

Oh i found the problem..
Your first date condition is wrong which should be >=

I want both dates. A1 will be entered a start date and A2 an end date. So there'll always be two dates.

The date range is listed in A3-A368. Next to each date is a value in B3-368.

Cool, well that fixed it for the first value I put in which is 12/3, but when I test it for another one which is 13/4, it appears to be adding in 12/3's occurrences too. Should ($B$3:$B$368<=B1) not have the < in it?

Yep, that fixed that adding problem. I changed the lookup value part to just = and it appears to be working in your formula. Thank you so much for the help! Much appreciated!

=COUNT(IF(($A$3:$A$368>=A1)*($A$3:$A$368<=A2)*($B$3:$B$368=B1),ROW($A3:$A368)))

So far this is working nicely. How would I put the percentage of days in a different cell? For example if the below example for a count on the value 12/3 on two days, 1/1/2000 through 1/2/2000 shows one day with that value (count of 1), I'd like in a nearby cell (we'll call B2) the percentage of days, in this case 50% since it was one of two days.

=COUNT(IF(($A$3:$A$368>=A1)*($A$3:$A$368<=A2)*($B$3:$B$368=B1),ROW($A3:$A368)))