View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macca macca is offline
external usenet poster
 
Posts: 18
Default How can I evade the limit of 30 arguments in a function?

I would like to add more than 30 cells and place that value in another cell.
I am being stymied at present by the limit of 30 arguments to a function. At
present, i must split the calculation, and then pick these split values and
tie them into my result cell. I know that this will work, but it seems messy
to my way of thinking.