Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUMIF??? (Excel 97)

    Function, Schmunction! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    OK.... I have a worksheet that is basically keeping track of responses to an invite... The columns in question are F (which holds a dollar amount or may be empty) and G (which holds text equivalent to "sent" or "will send check" or may be empty). I have been trying to write a SUMIF function that will start at the top of the range (F3:Fwhatever) and for each F that is greater than nothing, look at the corresponding G and see if it says "sent", then add all of the F's together that have a "sent" in their G column.

    Sadly, I am not able to return a value other than 0. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    ANY <img src=/S/help.gif border=0 alt=help width=23 height=15> is appreciated. Thanks. Jenn.

  2. #2
    New Lounger
    Join Date
    May 2002
    Location
    Colorado, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMIF??? (Excel 97)

    Hi Jenn,

    Try this formula:

    =SUMIF(G2:Gwhatever,"=sent",F2:Fwhatever)

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMIF??? (Excel 97)

    If the amounts are in F1 to F100, and the Text is in G1:G100, then the formula below, ARRAY ENTERED, should do what you asked:

    <pre>=SUM((F1:F100>0)*(G1:G100="sent")*(F1:F100) )
    </pre>

    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMIF??? (Excel 97)

    hot diggity! worked very well... I adapted it to work with the other value of "will send check" but it doesn't like the spaces... so a "will*" worked instead.

    Legare's suggestion worked great as well...

    hmmm, is there any way to blame the formula wizard for this??? LOL <img src=/S/notmyfault.gif border=0 alt=notmyfault width=15 height=15>

Posting Permissions

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