Counting cell on condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

navin - 31 Jan 2007 17:09 GMT

Hi,

I have sheet, in which Col A contains dates, now i have to calculate
the dates with the condition of >= and <=.

for example:

Col A

01/01/07
01/01/07
01/01/07
01/01/07
01/01/07
01/02/07
01/02/07
01/02/07
01/02/07
01/02/07
01/03/07
01/03/07
01/03/07
01/03/07
01/04/07
01/04/07
01/04/07
01/04/07
01/04/07

Now in cell B2,i have to count the dates which are between 01/01/07
and 01/02/07. Please help.

thanks,
navin

Reply to this Message

@Homeonthecouch - 31 Jan 2007 17:48 GMT

If you have the first 01/01/07 in A1 then try
=COUNTIF(A:A,A1)

Hope this helps

Andrew

> Hi,
>
[quoted text clipped - 30 lines]
> thanks,
> navin

Reply to this Message

Don Guillett - 31 Jan 2007 17:49 GMT

=sumproduct((a2:a22>=b1)*(a2:a22<b2))

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 30 lines]
> thanks,
> navin

Reply to this Message

Bob Umlas - 31 Jan 2007 19:14 GMT

=SUMPRODUCT(--(a2:a22>=b1),--(a2:a22<b2))
Bob Umlas

> Hi,
>
[quoted text clipped - 30 lines]
> thanks,
> navin

Reply to this Message

Rate this thread: