+ Reply to Thread
Results 1 to 2 of 2

sum for mutiple returns - formula needed. sumif?

  1. #1
    Registered User
    Join Date
    09-24-2007
    Posts
    66

    sum for mutiple returns - formula needed. sumif?

    I have a massave database that I need to add total qty associated with a sku that repeats numerous times with various quantities. I think it would be a sumif function, but I cannot figure it out.

    I have attached a sample file with the data I will be using.
    Attached Files Attached Files
    Last edited by mheinmiller; 11-18-2008 at 09:27 AM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi Mheinmiller,

    Is the following SUMIF function not working for you:

    =SUMIF(A2:A100,199175,C2:C100)

    ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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