+ Reply to Thread
Results 1 to 10 of 10

sumif problem

  1. #1
    Registered User
    Join Date
    10-21-2006
    Posts
    5

    Smile sumif problem

    hi all
    hopefully someone out there can help.

    i would like to know if anyone can figure out why my sum if function doesn't work, it seems right to me but i am also pretty computer illiterate. i'm a uni student and it's for an assignment.
    it's =SUMIF(input!$B$23:$B$1754,'Processing sales'!$A$2:$A$11,input!$C$23:$C$1754
    and also excel won't let me put quotation marks around my sum range; input, is this why it is not adding the values?
    thanks anyone who help me and if you need more info about the sum let me know.
    han

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Try using Ctrl + Shift + enter.

    Also I would assume the ranges should be the same e.g

    =SUMIF(Input!$B$23:$B$1754,'Processing sales'!$A$23:$A$1754,Input!$C$23:$C$1754)

    or use this non array version

    =SUMPRODUCT(--(Input!$B$23:$B$1754='Processing sales'!$A$23:$A$1754)*(--(Input!$C$23:$C$1754)))

    VBA Noob

  3. #3
    Registered User
    Join Date
    10-21-2006
    Posts
    5
    thank you so much for helping
    what did u mean by pressing ctrl + shift + enter? that must sound really dumb but i have no idea.
    also the new function you gave me
    =SUMIF(Input!$B$23:$B$1754,'Processing sales'!$A$23:$A$1754,Input!$C$23:$C$1754)
    does not make sense with my worksheets, im not sure what i am doin wrong but thank you so much for trying to help
    han

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    learn more about array's here

    http://www.cpearson.com/excel/array.htm

    And more about sumproduct here.

    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    VBA Noob

  5. #5
    Registered User
    Join Date
    10-21-2006
    Posts
    5

    thanks

    i have been able to understand what u meant by Ctrl + Shift + enter, unfortunately my function is still returning zeros and not adding, our lecturer only wants us to use the sum if function
    i think this might be a case of starting all over again
    thanks again for replying to my post
    han

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Post your example and I'll take a look.

    If you don't have zip then use

    http://cjoint.com/

    VBA Noob

  7. #7
    Registered User
    Join Date
    10-21-2006
    Posts
    5
    thanks han
    Attached Files Attached Files

  8. #8
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Works now.

    You had the numbers in Column B and C formatted as text

    VBA Noob
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    10-21-2006
    Posts
    5

    Talking

    wow i had 2 sleepless nights over that one
    i don't think i can say thanks enough
    han

  10. #10
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    No problem.

    VBA Noob

+ 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