http://www.contextures.com/xlFunctions04.html Use Excel COUNTIFS function to count the number of orders where the quantity is between 5 and 10. New function in Excel 2007 - for earlier versions, use Excel COUNTIF function.
Add more ranges and criteria quickly and easily to focus the formula results. Include wildcards for flexible criteria. Use a cell reference in the Excel COUNTIFS function to make the formula versatile and more powerful.
Link to this comment:
All Comments (0)