+ Reply to Thread
Results 1 to 12 of 12

Sumif code without size and colour

  1. 03-05-2016, 01:47 PM #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 code without size and colour

    Formula on D1 to drag down
    Last edited by makinmomb; 03-05-2016 at 01:51 PM.
    Reply With QuoteRegister To Reply
  2. 03-05-2016, 01:47 PM #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 code with size and colour

    column A1 downwards

    Code
    FL234BG36
    FL234BG38
    FL234BG39
    FL234BG40
    FL234C36
    FL234C37
    FL234C39
    FL234C40
    FL234M36
    FL234M37
    FL234M38
    FL234M39
    FL234M40
    FL284BG36
    FL284BG37
    FL284BG38
    FL284BG39
    FL284BG40
    FL284BG41
    FL284C36
    FL284C37
    FL284C38
    FL284C39
    FL284C40
    FL284C41
    FL284CM36
    FL284CM37
    FL284CM38
    FL284CM39
    FL284CM40
    FL284CM41
    FL286BG36
    FL286BG37
    FL286BG38
    FL286BG39
    FL286BG40
    FL286BG41
    FL286C36
    FL286C37
    FL286C38
    FL286C39
    FL286C40
    FL286C41
    FL286OL36
    FL286OL37
    FL286OL38
    FL286OL39
    FL286OL40
    FL286OL41
    FL295GD35
    FL295GD36
    FL295GD38
    FL295GD39
    FL295GD40
    FL295GD41
    FL295SL35
    FL295SL37
    FL295SL39
    FL295SL40
    Reply With QuoteRegister To Reply
  3. 03-05-2016, 01:48 PM #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 code with size and colour

    Column b1 downwards

    QTY
    1
    2
    1
    1
    2
    0
    2
    1
    2
    0
    2
    2
    2
    0
    1
    3
    1
    3
    2
    0
    0
    1
    2
    0
    0
    1
    2
    3
    1
    1
    3
    0
    0
    0
    0
    0
    0
    1
    0
    0
    0
    2
    1
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    0
    1
    0
    0
    0
    Reply With QuoteRegister To Reply
  4. 03-05-2016, 01:48 PM #4
    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 code with size and colour

    Column C downwards

    FL234
    FL284
    FL286
    FL295
    Reply With QuoteRegister To Reply
  5. 03-05-2016, 01:49 PM #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 code with size and colour

    column d downwards formula that should give results

    18
    24
    4
    1
    Reply With QuoteRegister To Reply
  6. 03-05-2016, 02:13 PM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Sumif code with size and colour

    This formula entered in D1 and copied down:

    =SUMIF(A:A,C1&"*",B:B)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  7. 03-05-2016, 02:14 PM #7
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,959

    Re: Sumif code without size and colour

    If that doesnt work, instead of posting a bunch of posts with just data in them, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  8. 03-05-2016, 02:34 PM #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 code without size and colour

    Fdibbins attaching these days on the site is not working
    Reply With QuoteRegister To Reply
  9. 03-05-2016, 02:35 PM #9
    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 code without size and colour

    Tony wow , the wild card , awesome , works
    Reply With QuoteRegister To Reply
  10. 03-05-2016, 02:40 PM #10
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,959

    Re: Sumif code without size and colour

    Test upload
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 03-05-2016, 02:40 PM #11
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,959

    Re: Sumif code without size and colour

    Seems OK to me?
    Reply With QuoteRegister To Reply
  12. 03-05-2016, 02:44 PM #12
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Sumif code without size and colour

    You're welcome. Thanks for the feedback!
    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] Remove size and colour
    By makinmomb in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 10-15-2015, 11:43 AM
  2. [SOLVED] Joint Description Size and Colour
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-12-2015, 06:08 AM
  3. Changing Font, Size, Colour in VB Email
    By Ebony Larkin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2015, 11:48 AM
  4. Need to format the content based on given Font size & colour
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-05-2015, 01:49 PM
  5. [SOLVED] Colour and font size in message popup
    By zugfrig in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 05-29-2013, 07:43 PM
  6. How to get a Watermark with a particular Size,Font and Colour?
    By e4excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-05-2011, 09:43 AM
  7. Stop font type, colour, size etc?
    By tazmanian24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2009, 07:48 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