Help: error on my formula. =(E20:E29)+(E31:E37)/2

[matkitdc]

Help: error on my formula. =(E20:E29)+(E31:E37)/2 - is there another way to do this?

thanks in advance

[canapone]

Hi maybe

Please Login or Register  to view this content.

or if you'd need to divide by two all the numbers

Please Login or Register  to view this content.

Regards

[matkitdc]

tnx for the quick reply. tried your formula =(E20:E29)+sum(E31:E37)/2, but it won't work. However, based on your formula. I added another sum at the beginning =SUM(E20:E29)+SUM(E31:E36)/2 and it works.

Thank You.

[canapone]

Hi, I've eaten a SUM: you're completelty right.

Thanks for the kind feedback.

Regards