Countif with and function

Closed
Report
-
Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
-
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

Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month