Hewlett-packard Pavilion dv6-3210us note...

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

The syntax goes like: =COUNTIFS(A1:A20,">=120",A1:A20,"<=139")

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

note the quote mark.

MIKE

Ask Your Question

Weekly Poll