What is it between the ranges you are trying to count that makes it
impossible to use the whole range like K2:K560? You can name part of formula
so it doesn't get too big, see


http://www.cpearson.com/excel/nested.htm

http://www.cpearson.com/excel/named.htm

although Chip shows how to deal with the 7 nested limits it can be applied
to long formulas as well


--
Regards,

Peo Sjoblom



"MML" wrote in message
...
I have figured out how to add mutliple ranges and criteria using the
countif
formula, but now I have a formula that is too long to fit in the cell
formula
bar. Won't let me complete the formula.

Is there a way to combine two ranges in the same formula statement like:

=countif('input'!k2:k4+k40:k45,"1") ?

I have a column k 1 thru 560 or so that I have to count either a 1,2,or 3
in, but I can't count the whole column at the same time, I have to count
mutliple ranges. I figured out how to do that, but now my formula is too
long?

Any help would be greatly apprecriated.
Thanks.