I have some data that is in two columns and looks something like this: 10 .39 -10 .54 -10 .67 10 .45
I need to get the sum of column 1 * column 2 but only when the value in column 1 is either negative or positive. In the past I've done this by creating two new columns before summing but I'd rather not keep creating columns to do this. Is it possible to do it in a single statement? I tried a couple of ideas with SUMPRODUCT but didn't find a way to do it. Thanks in advance, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
