N Norman Harker Jan 6, 2004 #2 Hi Ian! If they're all together: Example: =SUM(A1:J26) If they are not all together: Example: =SUM(A126,F1:K26) -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
Hi Ian! If they're all together: Example: =SUM(A1:J26) If they are not all together: Example: =SUM(A126,F1:K26) -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.