use criteria between 120 and 139

Hewlett-packard Pavilion dv6-3210us note...
June 19, 2011 at 12:48:54
Specs: WINDOWS 7, 4 GB
Excel Countifs Trying to count values that fall between two numbers like between 120 and 139 or 140 and 169. Need help with the syntax using Excel 2010 COUNTIF OR COUNTIFS FUNCTION

See More: use criteria between 120 and 139

Report •


#1
June 19, 2011 at 14:34:47
The syntax goes like:

=COUNTIFS(A1:A20,">=120",A1:A20,"<=139")

=COUNTIFS(A1:A20,">=140",A1:A20,"<=169")

note the quote mark.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question