How to count/sum the cells greater than but less than a number?

How to count/sum the cells greater than but less than a number?
There is a range of data in a worksheet as shown below, and now you want to count or sum the cells which are greater than a certain number but also less than another certain number in the range. Here, in Excel, COUNTIF and SUMIF formulas can help you.

Count the cells greater than but less than a number

Sum the cells greater than but less than a number

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).
Count the cells greater than but less than a number

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Hint

How to be more efficient and save time when using Excel?
Count the cells greater than a certain number but less than another certain number in a range. In this case, I count the cells greater than number 30 but less than number 50.

Please select a blank cell, for instance, the Cell C6, type this formula =COUNTIF(A1:C5,">30") - COUNTIF(A1:C5,">50") (the range A1: C5 indicates the range you want to count the cells which meet to the criteria, the number 30 and 50 stand the criteria, you can change them as you need), and press Enter button on the keyboard. See screenshot:

Sum the cells greater than but less than a number

For summing the cells greater than a certain number but also less than another certain number in a range, the following formula can help you.

Please select a blank cell, for instance, the Cell C6, type this formula =SUMIF(A1:C5,">30")-SUMIF(A1:C5,">50") (the range A1: C5 indicates the range you want to sum the cells which meet to the criteria, the number 30 and 50 stand the criteria, you can change them as you need), and press Enter button on the keyboard. See screenshot: