View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
emilr17 emilr17 is offline
external usenet poster
 
Posts: 4
Default applying formulas for all sheets selected

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.