running total of lines

CSharpGuy

I'm creating a Excel spreadsheet and I need to add a total of how many lines
were added to the spreadsheet. How can I keep a running total and then show
the total of how many lines were added to the spreadsheet?

Jun 13 '06 #1

Subscribe Post Reply

1118

George Ter-Saakov

I think you should use one of 2 avilable methods.

1. i = i + 1

or

2. i++.
you pick which one works best for you
George
"CSharpGuy" <CS*******@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

I'm creating a Excel spreadsheet and I need to add a total of how many
lines were added to the spreadsheet. How can I keep a running total and
then show the total of how many lines were added to the spreadsheet?

Jun 13 '06 #2

CSharpGuy

thanks, I got it working I actually used #2,, thanks
"George Ter-Saakov" <gt****@cardone.com> wrote in message
news:Oi**************@TK2MSFTNGP04.phx.gbl...

I think you should use one of 2 avilable methods.

1. i = i + 1

or

2. i++.
you pick which one works best for you
George
"CSharpGuy" <CS*******@gmail.com> wrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
I'm creating a Excel spreadsheet and I need to add a total of how many
lines were added to the spreadsheet. How can I keep a running total and
then show the total of how many lines were added to the spreadsheet?

Jun 13 '06 #3

Similar topics

Report: Running Total Problem

by: Bill Dika | last post by:

Hi I am trying to calculate a running total of a calculated textbox (tbAtStandard) in GroupFooter1 for placement in a textbox (tbTotalAtStandard) on my report in Groupfooter0. The problem...

Microsoft Access / VBA

How to start a running sum from other calculation

by: Peter Bailey | last post by:

I have a query that creates a graph of bookings from the course start date looking back 20 weeks based on a running sum. I also have a query that counts the number of bookings before that 20 week...

Microsoft Access / VBA

Keeping running total of part numbers entered into seperate fields

by: Shannan Casteel via AccessMonster.com | last post by:

I have a form for entering part numbers along with the associated quantity for each part. There are 25 Part fields and 25 associated Quantity fields. If I go to record 1 and enter part number 1234...

Microsoft Access / VBA

How to get the total row number of a text file

by: Wei Su | last post by:

Hi, I have a text file abc.txt and it looks like: 12 34 56 23 45 56 33 56 78 ... .. .. ... .. .. I want to get how many rows totally in the text file, how to do this? Thanks.

C / C++

Find the Total Lines in a log file?

by: Craig Bumpstead | last post by:

Hi, I was wondering the best and fastest way to determine how many lines are in a log file. At the moment I am simply doing a StreamReader.ReadLine and incrementing a counter until I reach...

C# / C Sharp

Create a Query that provides a running total but grouped?

by: Gandalf186 | last post by:

I need to create a query that produces running totals for every group within my table for example i wish to see: - Group A 1 5 9 15 Group B

Microsoft Access / VBA

UNIONs and Running Totals

by: trembita | last post by:

I have to databases that I connected together using a UNION. That was not a problem. I now need to create a running total using all of the data within the UNION. I can make a running total that...

Microsoft SQL Server

Running Total in Subreport Inaccurate

by: Jana | last post by:

Using Access 97. Background: I have a main report called rptTrustHeader with a subreport rptTrustDetails in the Details section of the main report. The main report is grouped by MasterClientID. ...

Microsoft Access / VBA

Calculate Running Total from Array

by: Stuart Shay | last post by:

Hello All: I have a array which contains the totals for each month and from this array I want to get a running total for each month decimal month = new decimal; month = 254; (Jan) month =...

C# / C Sharp

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General