SUMIF function - Page 2
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: SUMIF function

  1. #11
    Guest

    Default

     
    Is your data seperated into A course and B Course? If not have does your spreadsheet look.

  2. #12
    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

    Ok, got your workbook. What are you trying to SUMIF? Are you trying to get a sum for the profitable courses and/or the Non-profitable?

  3. #13
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,799
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default


    What is the assignment (in Dutch?) exactly?

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

    Default

    sorry but i dont speak dutch ... erm im just trying to find ... Total costs and total profits for traditional courses

    and also total costs and total profits for online courses
    both using the SUMIF function. In my spreadsheet i used SUM function cuz im not sure on how to use the sumif

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

  5. #15
    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

      
    Okay here goes:

    =SUMIF(C3:C16,"Traditional",D3:D16) gives the cost for traditional courses

    =SUMIF(C3:C16,"OnLine",D3:D16) gives the cost for online courses

    SUMIF(C3:C16,"Traditional",E3:E16) gives the profit for traditional courses

    =SUMIF(C3:C16,"OnLine",E3:E16) gives the profit for online courses

    Looking at the example immediately above it says "Look in the range C3 to C16 for OnLine. For every entry in range C3 to C16
    that equals Online, sum up the amount for that entry in the range E3 to E16.


    [ This Message was edited by: Steve Hartman on 2002-03-05 11:02 ]

    [ This Message was edited by: Steve Hartman on 2002-03-05 11:07 ]

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
  •  

 

 
DMCA.com