×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Students Click Here

Excel usage questions

Excel usage questions

Excel usage questions

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

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)
Thanks for answer #1.

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.


techsupportgirl@home.com

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 the cells are on the same page, your formula will look something like =SUM(AD4,AD14,AD24,AD34,AD44,AD54,AD64,AD75,AD85,AD95,AD105,AD114).[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.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close