Countif with and function

Closed
Julie - Jan 14, 2010 at 08:21 AM
tompols Posts 1219 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 14, 2010 at 12:12 PM
Hello,
I am trying to count cells in a column if they are greater than 60 and less than 29. How can this be done with a countif and function?
Thanks!
Julie

1 reply

tompols Posts 1219 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 28
Jan 14, 2010 at 12:12 PM
Hello,
how is this possible ? a number geater than 60 can never be less than 29 ???
anyway, if you're looking for a count of numbers between 29 and 60 in column A, it would be:
=SUMPRODUCT((A:A>29)*(A:A<60))
1