A new twist to this same question. All the percentages are mixed in with
cells with straight numbers. She only wants to the count the cells with
%ages.

"maryj" wrote:

I have a client that needs to count the number of values in a range that are
either greater than 100% or less than -100%. I'm assuming that we would need
to use some type of sumproduct.

Thanks for your help.

maryj