Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Floating AutoSum Cell

0

I need to create a report that takes the first Tab and makes it a Summary Data page, on the next 4 tabs - these will be data gathered from different dates and time spans and make this entire Workbook as template - 

On any one of those 4 later tabs there could be anywhere from a couple hundred rows to a couple thousand rows.

I need to have certain columns have an AutoSum applied and carry it over to the Summary Page - 

The question is, how do I create a 'Floating' AutoSum Cell for those columns so that no matter how many rows of data I paste in, it will apply the AutoSum on the last row?

Thanks!

Answer
Discuss

Answers

0

A formula like =SUM(Sheet2!$C$2:$C$10000) would include all the rows with data in them as well as many rows without any data. All the empty cells would have a value of zero. Therefore the formula would return the true sum of all values in the column.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login