Is there an easier way to add this up??

[pano]

Hi there,

Is there an easier way to add these cells up, I know it does what it's supposed to but is there a cleaner looking solution.

I have

=back1!F5+back1!E5+backa!F5+backa!E5

any takers?
any help appreciated.

 

[julxl]

=SUM(back1!E5:F5,backa!E5:F5)

 

[Stormseed]

=SUM(back1:backa!E5:F5)

 

[Brian from Maui]

Hi there,

Is there an easier way to add these cells up, I know it does what it's supposed to but is there a cleaner looking solution.

I have

=back1!F5+back1!E5+backa!F5+backa!E5

any takers?
any help appreciated.

Insert two new worksheets and name them First and Last. Place all relevant sheets between the two and use,

=SUM(First:Last!E5:F5)

or if you don't plan to add anymore sheets,

=SUM(Back1:Backa!E5:F5)