+ Reply to Thread
Results 1 to 10 of 10

Need help in code sumif

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    13

    Smile Need help in code sumif

    Hello
    is there is a way to write a code to do something like (sumif (a:a , (start with ) , c:c) something like that
    i want to sum if the cells starts with word like (anything)

    Thanks

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Need help in code sumif

    Yes, but why use code if a sumif works?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    01-08-2015
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    13

    Re: Need help in code sumif

    well...i dont know how to do it with sumif :D

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Need help in code sumif

    Hi gostavee (My country's son)
    May be something like that
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Need help in code sumif

    Hi gostavee (My country's son)
    May be something like that
    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Need help in code sumif

    or just
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    01-08-2015
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    13

    Re: Need help in code sumif

    Thanks guys, but i didn't mean anything like its what i'm looking for ...here is the thing i want code to sum a:a if cells value starts with "me" like if the the cell got value of "me and you" it will sum it because it got "me" at the start of the value ..that's what i meant and thanks again

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Need help in code sumif

    Try this
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    01-08-2015
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    13

    Re: Need help in code sumif

    Great it works thanks alot :D

  10. #10
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Need help in code sumif

    You're welcome. Thanks for the feedback my brother

+ 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. VBA Code for Sum & SumIf
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2013, 11:10 AM
  2. Excel 2007 : SUMIF help:code MA
    By CSWEENY9 in forum Excel General
    Replies: 8
    Last Post: 01-24-2011, 06:22 PM
  3. SumIf help-what the proper code
    By KenpoHai in forum Excel General
    Replies: 2
    Last Post: 10-19-2006, 05:01 PM
  4. How to simplfy If & Sumif Code
    By Martin in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 05:35 AM
  5. Code: SUMIF
    By broogle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1