Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUMM GG (2000 sr 1)

    This sheet contain a planning of vacation.
    My problem is:

    To summ every value present in the column GG (refered from every NOMINATIVO) and insert the result (in to a parentesis) in the column C after the name...

    Example:

    UBALDI GENNARO (SUMM FOR EVERY COLUMN GG)

    In this case

    UBALDI GENNARO (13,0)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SUMM GG (2000 sr 1)

    How do you want this?
    It could be done with formulas, but in another column (you need to keep the NOMINATIVO column).
    Or the values in column C can be replaced, but that makes it hard to maintain: changing one of the GG values would not automatically update column C.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMM GG (2000 sr 1)

    ... my dear if i delete the value present in C is not a good idea...
    My problem is to add after this the value the summ of column GG

    My idea is to del the nominativo and store this in a vriable after, re-joint this with the summ in to column C..
    Or this not is a good idea...

    If you have another idea... For me is important to mantain the value in the column C

    Wizard if i attach a code of my macro to import the data in to sheet peraph is most sinple to resolve my problem?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SUMM GG (2000 sr 1)

    I have attached a possible solution, but it doesn't work yet.
    - I have inserted a blank column to the right of column C
    - I copied column C to the blank column D.
    - D now contains the names.
    - I created formulas in column C to display Name (Sum)

    BUT all the columns with GG data are formatted as text (in Format | Cells...), so Excel will not perform calculations with these data; they are all seen as 0. You will have to repair this yourself, for example as follows:
    - Select the columns with GG data.
    - Select Format | Cells...
    - Activate the Number tab.
    - Set the format to General.
    - Click OK.
    - Select an empty cell.
    - Copy it to the clipboard (Edit | Copy)
    - Select the cells in one or more columns with GG data.
    - Select Edit | Paste Special...
    - Click the Add option.
    - Click OK.

    WARNING: the spreadsheet became too large, even zipped, so I have removed most of the data. DO NOT replace your own version with the one I attach here!

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMM GG (2000 sr 1)

    Wizard if you like i attach a code of my macro to import the data in to sheet, peraph is most simple to resolve my problem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •