Thread: how do I increase the number of cells I want to total
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Naveen Naveen is offline
external usenet poster
  
Posts: 100
Default how do I increase the number of cells I want to total
Excel has sum limitation on "SUM".

please try with subtotal, available in "Data" menu.


*** Please do rate ***







"acking62" wrote:

I'm trying to total
=SUM(D3,D11,D19,D27,D35,D43,D51,D59,D67,D75,D83,D9 1,D99,D107,D115,D123,D131,D139,D147,D155,D163,D171 ,D179,D187,D195,D203,D211,D219,D227,D235)
I need to extend this further but can't add any more do to error. How can I
add more cells to calculate?

Reply With QuoteReply With Quote