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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!