Countif

R

reno

is it possible to use <,<=,=>,> operators, such as
countif(a1:a20,"<breakpoint"), where breakpoint is a named variable.
want to use w/cond formatting and highlight and give a count of instances.
any ideas? thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
Counting independent items in a list 3
countifs Function not giving desired result with date criteria 2
Finding the weighted average of text that have been given values 1
Countif 2
COUNTIFS using multiple named ranges in the criteria 0
COUNTIF oddity 1
Count Number of Unique Cells That Don't Have Certain Characters 0

Top