• SUMIF??? (Excel 97)

    Author
    Topic
    #377064

    Function, Schmunction! confused

    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. sad

    ANY help is appreciated. Thanks. Jenn.

    Viewing 1 reply thread
    Author
    Replies
    • #619975

      Hi Jenn,

      Try this formula:

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

      • #619985

        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 notmyfault

    • #619980

      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:

      =SUM((F1:F100>0)*(G1:G100="sent")*(F1:F100))
      
    Viewing 1 reply thread
    Reply To: SUMIF??? (Excel 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: