Allowing for a range using COUNTIF

D

desi

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
 
J

John Michl

Stephen -

Use SUMPRODUCT such as

=SUMPRODUCT((A1:A100>30)*(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
 
Top