+ Reply to Thread
Results 1 to 10 of 10

Sum exclude duplicates if below each other

Hybrid View

stimpy123 Sum exclude duplicates if... 08-03-2014, 08:25 AM
oeldere Re: Sum exclude duplicates if... 08-03-2014, 08:33 AM
stimpy123 Re: Sum exclude duplicates if... 08-03-2014, 08:52 AM
sktneer Re: Sum exclude duplicates if... 08-03-2014, 09:31 AM
stimpy123 Re: Sum exclude duplicates if... 08-03-2014, 09:54 AM
sktneer Re: Sum exclude duplicates if... 08-03-2014, 10:03 AM
stimpy123 Re: Sum exclude duplicates if... 08-03-2014, 10:19 AM
Vikas_Gautam Re: Sum exclude duplicates if... 08-03-2014, 10:04 AM
sktneer Re: Sum exclude duplicates if... 08-03-2014, 10:25 AM
AlKey Re: Sum exclude duplicates if... 08-03-2014, 10:35 AM
  1. #1
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Sum exclude duplicates if below each other

    In the formula
    =SUM(IF(A2:A11="",A1:A10))
    you have to pay attention to the cell references in red.
    Where A1= the cell just above your first number and A11=the cell below the last sum of a group, assuming your numbers are in the range A2:A10.

    Change it as per your need and if this doesn't work, it would be better if you upload a sample workbook.
    See the attached sheet where the formula is applied for the example data in post#1.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  2. #2
    Registered User
    Join Date
    08-02-2014
    Location
    london
    MS-Off Ver
    2011 mac
    Posts
    6

    Re: Sum exclude duplicates if below each other

    Thanks got it to work!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 09-11-2013, 05:58 PM
  2. SUMIFS and exclude Duplicates with a table reference
    By GOQC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2013, 01:24 PM
  3. Replies: 5
    Last Post: 08-29-2012, 11:35 AM
  4. Sum column exclude duplicates
    By ryan@csi in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-18-2009, 02:40 PM
  5. Count 350 SS numbers, exclude duplicates
    By Marsha in forum Excel General
    Replies: 5
    Last Post: 03-07-2005, 02: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