×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Excel usage questions

## Excel usage questions

(OP)
I've looked in Excel help, but could not find the

1. If I enter a date on sheet1 A10 how do I get
that date to automatically appear on sheet2 B12?

2. I have columns with totals...

A12 = sum(a3;a11)
A24 = sum(a13;a23)
etc.

I have 60 totals.
Now I need a GRAND Total.
Is there a way to do this other than including
each total (A12,A24,A36 to A5##) in a series
of sum commands?
Glenn

### RE: Excel usage questions

Glenn,

1.  Just set the formula for "sheet2 B12" equal to "sheet1 A10"  To do this, click in "sheet2 B12" and type the equal sign.  Then click in "sheet1 A10".  Your formula for "sheet2 B12" will look like
=[Sheet1]!A10

2.  If I understand your question, couldn't you just sum all the entries and divide by two?  It's sneaky, but it should do what you want.  If that won't work for you, let me know and I will do some stuff with Iif...then formulas.

### RE: Excel usage questions

(OP)

Regarding #2... It looks more like this...a correction
on my part...

A      B
1    5.00
2    6.00
3    7.00
4   18.00   Sub Total
5
6    4.00
7    4.00
8   23.00
9   31.00   Sub total
10
11   6.00
12   8.00
13   3.00
14  17.00   Sub total
etc
to a total of about 70 subtotals.

I cannot enter the whole string into a sum command.
I want a4+a9+a14 out to 67 more sub totals

I can create several sums and then sum them together.
This is okay...but I then need all but the grand total
to be invisible.

Glenn

### RE: Excel usage questions

If you don't put completely blank rows or columns in your data, you can use the Data-Subtotals feature. If you're putting blank rows/columns to visually separate your data, it won't work.

### RE: Excel usage questions

The best way I know to sum a large # of cells is the following:

1. Click in the "Grand Total" cell
2. Click on the equals sign and select SUM
3. Click the Cell Select button at the side of the "Number 1" field
4. Click in the first Subtotal cell
5. Click the Cell Select button again
6. Repeat for each Subtotal Cell by selecting "Number2,3,..[b/]"
7. Once done click OK[b/]

If they are on other pages, each selection will also include the page reference.

Good Luck

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!