hi
there is no real hocus pocus stuff involved. it just how you wright the
formula
vertical......
=sum(A1:A20) 'note: all column A
horizontal......
=sum(A1:R1) 'note: All row 1
diagonal.....
=sum(A1,B2,C32,D4,E5) note: 45 degree down from A1
sporatic....
=sum(R20,V2,AB599,B1,U2,X65000) note: uh...all over the place

any other way you want it?

Regards
FSt1

"Melissa in Salem" wrote:

I know how to create formulas for calculations as long as the numbers
are stacked vertically, like adding top to bottom.

How do make formulas that go across the page horizontally? Is that
possible? I am sure it is but I am stumped.