Allowing for a range using COUNTIF
 

All -

I need to do an aging report in excel and I want to use the countif
statement to get the number of items less than 30 days old (<30) got
that one.

The one I am stuck on is Count the item if it is 30 and less than 60
days old.

How can I do this?

-stephen


--
desi

Software Engineer
------------------------------------------------------------------------
desi's Profile: http://www.excelforum.com/member.php...fo&userid=7732
View this thread: http://www.excelforum.com/showthread...hreadid=505055

Allowing for a range using COUNTIF
 

Stephen -

Use SUMPRODUCT such as

=SUMPRODUCT((A1:A10030)*(A1:A100<60))

This will be produce two arrays of True and False results, also
represented as 1 and 0. If TRUE to the first and FALSE to the second
the product pair would be 1 * 0 or 0. If it meets both criteria the
pair would be 1 * 1 or 1. Summing the product pairs will be the same
as a count.

- John

www.JohnMichl.com

Allowing for a range using COUNTIF
 

Hi!

Try this:

=COUNTIF(A1:A10,"30")-COUNTIF(A1:A10,"=60")

Biff

"desi" wrote in message
...

All -

I need to do an aging report in excel and I want to use the countif
statement to get the number of items less than 30 days old (<30) got
that one.

The one I am stuck on is Count the item if it is 30 and less than 60
days old.

How can I do this?

-stephen


--
desi

Software Engineer
------------------------------------------------------------------------
desi's Profile:
http://www.excelforum.com/member.php...fo&userid=7732
View this thread: http://www.excelforum.com/showthread...hreadid=505055