Results 1 to 9 of 9

How to sum up duplicate data by using sumif?

Threaded View

yiyi2 How to sum up duplicate data... 05-30-2022, 05:10 AM
ardross Re: How to sum up duplicate... 05-30-2022, 05:14 AM
yiyi2 Re: How to sum up duplicate... 05-31-2022, 04:41 AM
AliGW Re: How to sum up duplicate... 05-30-2022, 05:15 AM
yiyi2 Re: How to sum up duplicate... 05-31-2022, 04:42 AM
ardross Re: How to sum up duplicate... 05-30-2022, 05:19 AM
AliGW Re: How to sum up duplicate... 05-31-2022, 04:42 AM
AliGW Re: How to sum up duplicate... 05-31-2022, 04:44 AM
yiyi2 Re: How to sum up duplicate... 05-31-2022, 05:11 AM
  1. 05-30-2022, 05:10 AM #1
    yiyi2 is offline
    Registered User
    Join Date
    05-14-2018
    Location
    Hong Kong
    MS-Off Ver
    MS 365
    Posts
    82

    How to sum up duplicate data by using sumif?

    need to sum up "units ordered" from tab "7days" at tab "daily sales" but it does not get correct value. Not sure if my formula with any questions.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sumif issue with duplicate criteria
    By Portz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-06-2015, 01:02 PM
  2. SUMIF for duplicate data points
    By rwrig in forum Excel General
    Replies: 2
    Last Post: 10-25-2013, 10:53 AM
  3. How to use sumif and advoid duplicate ids
    By tantcu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2013, 03:24 PM
  4. [SOLVED] Sumif duplicate value
    By Jeffrey Ting in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2012, 09:07 PM
  5. Return and non-duplicate SUMIF data
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-22-2012, 08:19 AM
  6. SUMIF duplicate
    By magman1984 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 08-31-2011, 10:18 AM
  7. Disallow duplicate entries using SUMIF
    By adamwestrop in forum Excel General
    Replies: 3
    Last Post: 08-01-2011, 04:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1