+ Reply to Thread
Results 1 to 9 of 9

SUMIF for category sales

  1. 04-02-2016, 10:30 AM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    SUMIF for category sales

    Formula on G2 to drag right and down
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-02-2016, 10:30 AM #2
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF for category sales

    Shoes Gents Shoes Ladies Shoes Kids Accessories Leather Chappals
    Reply With QuoteRegister To Reply
  3. 04-02-2016, 10:31 AM #3
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF for category sales

    How much of these sold date wise
    Reply With QuoteRegister To Reply
  4. 04-02-2016, 10:36 AM #4
    CplSmudge
    CplSmudge is offline
    Registered User
    Join Date
    04-24-2012
    Location
    Wiltshire, England
    MS-Off Ver
    Office 365
    Posts
    44

    Re: SUMIF for category sales

    formula for across the columns is done, SUMIF totals the column so why do you want it to copy down?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 04-02-2016, 10:38 AM #5
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF for category sales

    CPL date is not working , works for row 1 only
    Reply With QuoteRegister To Reply
  6. 04-02-2016, 10:39 AM #6
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF for category sales

    there needs to be a change in the formula , for it to smell date
    Reply With QuoteRegister To Reply
  7. 04-02-2016, 10:48 AM #7
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: SUMIF for category sales

    Hi Try this Cell G2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Copy down and a cross
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".
    Reply With QuoteRegister To Reply
  8. 04-02-2016, 10:50 AM #8
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,626

    Re: SUMIF for category sales

    Thank you very much
    Reply With QuoteRegister To Reply
  9. 04-02-2016, 10:58 AM #9
    CplSmudge
    CplSmudge is offline
    Registered User
    Join Date
    04-24-2012
    Location
    Wiltshire, England
    MS-Off Ver
    Office 365
    Posts
    44

    Re: SUMIF for category sales

    If you change the text dates to dates format you could use SUMPRODUCT as in the example
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Category sales branch wise
    By makinmomb in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-13-2015, 01:13 PM
  2. [SOLVED] Help using SUMIF function or others for daily sales
    By irene26 in forum Excel General
    Replies: 3
    Last Post: 11-16-2014, 06:04 AM
  3. [SOLVED] Using =G8-SUMIF('MASTER SALES'!C:C,A8,'MASTER SALES'!J:J) but I forgot to include # sold
    By Just Splurge in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2014, 02:33 AM
  4. [SOLVED] How to Sum Up sales data by a product category from another sheet
    By Jason_Shanghai in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2005, 04:25 PM
  5. How to Sum Up sales data by a product category from anther sheet
    By mel_zhang in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-21-2005, 03:32 PM
  6. Summing Sales Amounts According to Product Category and Customer Name
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:07 AM
  7. Automatic Sum by Category (SumIf extension)
    By ezuk in forum Excel General
    Replies: 1
    Last Post: 08-12-2005, 02:05 AM

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