Countif with and function
Closed
Julie
-
14 Jan 2010 à 08:21
tompols Posts 1273 Registration date Wednesday 28 July 2004 Status Contributor Last seen 25 November 2013 - 14 Jan 2010 à 12:12
tompols Posts 1273 Registration date Wednesday 28 July 2004 Status Contributor Last seen 25 November 2013 - 14 Jan 2010 à 12:12
Related:
- Countif with and function
- Hard drive function - Guide
- Network card function - Guide
- Iserror function in excel with vlookup - Guide
- Mutator function c++ - Guide
- Vba find function - Guide
1 response
tompols
Posts
1273
Registration date
Wednesday 28 July 2004
Status
Contributor
Last seen
25 November 2013
28
14 Jan 2010 à 12:12
14 Jan 2010 à 12:12
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))
