![]() |
Sum only adding rows on page instead of entire spreadsheet - help
I have a large spreadhseet and I am trying to SUM columns of data but the SUM
function is only adding a page at a time instead of the entire spreadhseet. I have no page breaks, section breaks or other formatting in place. I have tried doing the function manually (=SUMAH2:AH518) but that just gives me an error message. Any ideas? |
Sum only adding rows on page instead of entire spreadsheet - help
(=SUMAH2:AH518)
try =sum(ah2:ah518) -- Kevin Vaughn "Sarah" wrote: I have a large spreadhseet and I am trying to SUM columns of data but the SUM function is only adding a page at a time instead of the entire spreadhseet. I have no page breaks, section breaks or other formatting in place. I have tried doing the function manually (=SUMAH2:AH518) but that just gives me an error message. Any ideas? |
All times are GMT +1. The time now is 06:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com