Countif with and function
Closed
Julie
-
Jan 14, 2010 at 08:21 AM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 14, 2010 at 12:12 PM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 14, 2010 at 12:12 PM
Related:
- Countif with and function
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Hard drive function - Guide
1 response
tompols
Posts
1273
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
Jan 14, 2010 at 12:12 PM
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))
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))