Countif Formula

[Quinton]

Hello, I have 2 seperate excel files & I would like to do the following if possible.

I have a date of "16.03.11" in one excel Spreadsheet. I would like to be able to count that date in another excel spreadsheet (show result as 1) if it sits within a range of dates. So basically as "16.03.11" sits within a range of March 11 (or 01.03.11 to 31.03.11) it produces a count of "1".

Is this possible?

ps - sorry it was a hard one to explain!

Cheers in advance

 

[Dryver14]

if date is in A1

in A2 = countif(select range of dates,A1)

 

[Quinton]

Thanks, but I don't know how to select the range of dates. This was my original question?

Cheers,

 

[Dryver14]

ok in A2 type =countif(

then click on the sheet where your dates are select the top cell and scroll down to the last date

click back on the sheet you are typiing the formula in and type the comma

then click on the cell that has the date you need to find

close bracket )

 

[Quinton]

Many thanks - I have obviously not explained myself properly. Let me try again. The range of dates are not in different cells (range was probably not the best word). I have 1 date in 1 cell that I am trying to "Count" providing it fits certain criteria.

Say for example I have a date of 16.03.11 in a cell. I want to count that as "1" in another cell, providing the date is between 01.03.11 - 31.03.11 i.e. in this case the month of March in 2011.

Hope this helps!

Cheers,

 

[Quinton]

Re: Countif Formula (Help Pelase)

Can anyone else help!!!!

Eternally grateful!!!!!

 

[JazzSP8]

Hi

I think I understand what you mean, basically you want to count dates between two points?

Using your example your formula should be something like...

=COUNTIF(A:A,">01/03/2011")-COUNTIF(A:A,">01/04/2011")

Amend the range of cells to suit

HTH

 

[Adnym]

Hi Quinton,

You haven't said which version of Excel you're using, but for 2007 you can use a formula like this:

=COUNTIFS(A1:A50,">28/02/2011",A1:A50,"<01/04/2011")

Assuming A1:A50 is the range you want counted.

______________________________________________
Excel Training

 

[Quinton]

Many thanks Jazz!!

Works like a DREAM!

Yippppeeeee

 

[JazzSP8]

Many thanks Jazz!!

Your welcome