# Thread: SUMIF??? (Excel 97)

1. ## 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. ## Re: SUMIF??? (Excel 97)

Hi Jenn,

Try this formula:

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

3. ## 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>

4. ## 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
•