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