Need to autosum ranges of cells within multiple pages and then sum those as well.

Could do with more information as to what you're creating a sum for. Can you upload an example workbook (with mock data) to show what you want to sum and we can provide a formula and be able to understand why you get the error.

To post with a file attache click Go Advanced. Then choose manage files to upload a workbook and Insert Inline to add to your post.