ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sum only adding rows on page instead of entire spreadsheet - help (https://www.excelbanter.com/excel-discussion-misc-queries/71924-sum-only-adding-rows-page-instead-entire-spreadsheet-help.html)

Sarah

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?

Kevin Vaughn

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