sorry. no none of the worksheets are protected and im not running out of
memory. there are no error messages. i can type in the formula into a sheet
and it works, once i go into select all sheets (group) and try to put the
formula in it won't apply to all over them. i tried just putting
=SUM(k59:k61) and it worked. but when i put my entire forumla it doesn't.

"Gary Brown" wrote:

You haven't explained what 'it won't' means BUT...
- are you running out of memory?
- are some worksheets protected?
- do you have error messages in some of the cells?
- etc, etc, etc
--
Gary Brown


"emilr17" wrote:

i am working on a spreadsheet with over 60 sheets. i am trying to apply one
formula to all the sheets but it won't. this is the formula
=SUM(K24:K28,K32:K34,K36,K38:K39,K42:K43,K55:K56,K 59:K62,K68:K69,K97:K105,K116,K133,K137:K138,K148:K 149,K159,K157,K161:K164,K181:K182)
does anyone know why this wouldn't apply to all of them.