Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: SUMIF function

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i have a question ... i have an assignment to do and this is what it asked me to do.
    Create a Summary worksheet containing:
    Total Costs and Total Profits for A course
    Total Costs and Total Profits for B course.
    use the SUMIF function to calculate these costs

    how do i use SUMIF?? i mean i can probably just use SUM function to calculate it ... but the course guide ask me to use SUMIF ... anyone ?

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  3. #3
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Look up sumif in the Excel help files.

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i dont quite understand the excel help. cuz using the SUMIF function .. it'll sum up the figures if i put something for the function to compare ... but the thing is ... i have nothing to compare ... and i can only use the SUM function to total up the costs and profits. so it's either my course guide is telling me to put the wrong function or ... theres something for me to put in my sheet in order for the SUMIF to lookup to

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-05 08:39, choungeehowe wrote:
    i have a question ... i have an assignment to do and this is what it asked me to do.
    Create a Summary worksheet containing:
    Total Costs and Total Profits for A course
    Total Costs and Total Profits for B course.
    use the SUMIF function to calculate these costs

    how do i use SUMIF?? i mean i can probably just use SUM function to calculate it ... but the course guide ask me to use SUMIF ... anyone ?
    Care to provide 10 rows of data which you're supposed to summarize per course?

  6. #6
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could you give a little more info on how your sheets are laid out?

    Since you are creating a summary sheet, I assume you have a bunch of data on another sheet? You would use SUMIF on your summary sheet and it would reference the data on the other sheet.

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry if its too much trouble. heres the spreadsheet. http://www.geocities.com/choungeehow...ways_right.xls


    under the 'Summary' sheet . I have put in my total there using the SUM function. But my course guide wants me to use the SUMIF. So from there i dont know how to use the SUMIF function.

  8. #8
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Clicking the link gives me a page not available error. Sure the address is correct?

  9. #9
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perhaps this will enlighten?

    http://www.cpearson.com/excel/array.htm
    ~Anne Troy

  10. #10
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    arghh... if the pic doesnt show ... its http://www.geocities.com/choungeehowe/

    [ This Message was edited by: choungeehowe on 2002-03-05 10:50 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •