Results 1 to 12 of 12

Sum special range

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Sum special range

    Hello everybody
    In my attachment I have a selection for the range A1:I11 .. the last row is blank ..
    Based on selection I want to get the results in Column J based on Column G
    Situations:
    G1 is blank so J1 is blank.

    G2 has a unique name so J2 will have the same value as in I2.

    G3 and G5 and G6 and G10 has the same name so I want to sum the values in column I which related to that name and the result appear once at J3

    G4 and G7 the same situation as G2.

    G8 and G9 has the same name so to sum the values in Column I related to those names and to get the result in G8 only

    The desired results are shown in the attachment
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy range using paste special
    By Shaun1978 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2013, 09:45 AM
  2. [SOLVED] Range in code gives special problem
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2013, 03:21 AM
  3. Select Range Paste Special
    By additude in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-30-2007, 01:09 PM
  4. select special range
    By harold84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2007, 07:25 AM
  5. Range name special characters
    By Charley Kyd in forum Excel General
    Replies: 3
    Last Post: 02-11-2005, 06:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1