Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Adding totals to data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Adding totals to data

Resolved · Medium Priority · Version 2003

Reply Mon 6 Oct 2008, 16:00Delegate Richard said...

Richard has attended:
Excel VBA Intro Intermediate course

Adding totals to data

Hi there,

im having trouble working out how to total information once I've maniuplated the data into a suitable fashion. After the data has been successfully altered, it has 8 columns, (A-H) and currently has 4,481 rows of data. I need to total the data in columns C-H, but the total number of rows will differ depending when the report is run. I also do not want to include the column headings when totalling the data.

I think I should use something like, Now Rows = Activecell.CurrentRegion.Rows.Count within the code to do this, but im unsure of the rest. Do I need to use a counter?

Any help will be gratefully received!

For upcoming training course dates see: Pricing & availability

Reply Tue 14 Oct 2008, 10:17Trainer Stephen said...

RE: Adding totals to data

Hi Richard

Thank you for your question.

Can you clarify something for me please? Do you wish to count the total number of rows, or sum the values in the rows?

Regards

Stephen

Excel articles

· Creating And Importing Custom Lists In AutoFill
· Tips To Help You Excel
· Making The Most Of Filtering In Excel
· Find Out Your Age In Days With Excel
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Please browse our web site to find out more about
excel 2003 training and other Microsoft training courses.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips