Try grouping some of the cells within brackets, something lie this

=SUM((A5,A7,A11,A4,A17),(C5,C11,C9),...

--
__________________________________
HTH

Bob

"Miki" wrote in message
...

I'm facing problem while using sum or average formulas in same worksheet
when I try use it for more than 30 different cells. It calculates only 30
and
if I try to add more it gives error.


Is there any solution for the same.