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