Excel query

Computing.Net > Forums > Office Software > Excel query

Original Message

Name: Dawie
Date: April 26, 2008 at 12:35:28 Pacific
Subject: Excel query
OS: Win XP sp2
CPU/Ram: 1000mb

Comment:

Just a question. Imagine a table with 3 columns. In columns 2 and 3 I need to add figures. At the bottom of 2 and 3 I need a cumulated total everytime I key in figures. What is the formulae for that? Thanx in advance.
When was the last time you did something for the first time?

Report Offensive Message For Removal

Response Number 1

Name: DerbyDad03
Date: April 26, 2008 at 18:22:29 Pacific
Subject: Excel query

Reply: (edit)

re: When was the last time you did something for the first time?
Right now! This is the first time I'm asking you to explain what you want to do in a little more detail. <g>
The obvious answer to your question seems so simple like I doubt it's what you are looking for:
Assuming you know how big your table is, you simply use something like =SUM(A1:A100) in A101, which, in my example, is the bottom of a 100 row table.
That can't be the answer...is it?

Report Offensive Follow Up For Removal

Response Number 2

Name: Dawie
Date: May 21, 2008 at 12:12:07 Pacific
Subject: Excel query

Reply: (edit)

Thanks. That's it!
When was the last time you did something for the first time?

Report Offensive Follow Up For Removal


Excel queries Excel Query Problem Excel Query excel question - conditional format Excel: Remove data to another sheet	Printing out an address book Excel Query Excel 2000 Web Query Excel 2007 New Database Query Ms Query & Excel

Calendar in Word to Outlo...

OpenOffice Line return

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Excel query

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Can anyone help with this problem?

Fail to open JPEG Outlook 2003 att

CPU Runs slow after upgrade Dothan

IEEE 1394 controller driver

desktop problem

All Posts Awaiting Replies