Using Date Range to Count additional colums

[tlceph415]

Hello all, New to the board I am glad I found you all . There is a lot of data here that I will be using often.

I am setting up a report to look at data from on tab that calculates range and criteria from another tab.

I need a formula that will look at my Date Column and if the date falls between the 1st and the 30th or 31st of the month I need it to count numbers in another column.

Number of People in Household Date of First Visit
7 10/12/2005
5 10/12/2005
5 10/12/2005
5 10/12/2005
6 10/12/2005
2 10/12/2005


Any help is appreciated.

Thank You!

TLCEph415

 

[venkat1926]

it is not clear what is meant by quote
1st and the 30th or 31st of the month unquote
any dte wil be between 1 and end date

besidses the dates are all the same. eithe index-match or vlookup will find out any one of these same dates mostly the first one.

how are the dates entered 10/12/05 does it mean october 12th?????

please clarify.

 

[tlceph415]

reply

it is not clear what is meant by quote
1st and the 30th or 31st of the month unquote
any dte wil be between 1 and end date

Thank you for the responce

Here is what I came up with from viewing other simular questions on the board to get my needs met, but as you can see I have to use 2 different formula's to identify the date that I want to find out of the month query I then sum the 2 results to identify how many times each date occured.

=SUMPRODUCT(('Customer Sign-In Data'!D7:D4999=38637)*(A3=A4)*'Customer Sign-In Data'!C7:C4999)

=SUMPRODUCT(('Customer Sign-In Data'!D7:D38=38650)*(A3=A4)*'Customer Sign-In Data'!C7:C38)

My goal is to develop a report that will use the data on a mo to mo basis to identify how many people where served during that mo.

besidses the dates are all the same. eithe index-match or vlookup will find out any one of these same dates mostly the first one.

# People Date of First Visit
7 10/12/2005
5 10/12/2005
5 10/12/2005
5 10/12/2005
4 10/25/2005
3 10/25/2005
3 10/25/2005
5 10/25/2005

how are the dates entered 10/12/05 does it mean october 12th?????

Yes

Thanks again sorry for the lack of correct info.