Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
How do I count only those values in a range that are between two numbers?
Posted by - NA - on 28 March 2006 05:38 AM
|
|
Solution: Use the array formula =SUM((A1:A10<=High)*(A1:A10>=Low)) where High and Low are the limits you want. | |
|
Comments (0)