Function, Schmunction!
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.
ANY is appreciated. Thanks. Jenn.