Help With Function

[Macdave_19]

Hi all,

really need some help amending this great function provided to me by richard buttery (Many Thanks).

At the moment this only works for a joined range i.e. =AddOvers(A1:A10)

However i need to use it as follows: =AddOvers(A1,B7,G9,A3)

Is there an amendment somone could advise of that will allow me to use this function as above?

Please Login or Register  to view this content.

Any help is greatly appreciated folks!!

[Andy Pope]

Please Login or Register  to view this content.

[Macdave_19]

Andy Pope = Legend!!

thanks ever so much dude!!!