I assume the cells are not contiguous ... can you post example of your formula?

"macca" wrote:

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.