That's the 3 column solution I already use but would like to get away from.
On Mon, Sep 22, 2008 at 10:36 AM, Randy Graham <[EMAIL PROTECTED]> wrote: > Column 3 formula shuold look like this =if(C4<>0;C4*D4;" ") > Then sum column 3 > > -----Original Message----- > From: Mark Knecht [mailto:[EMAIL PROTECTED] > Sent: Monday, September 22, 2008 12:16 PM > To: [email protected] > Subject: [users] Conditional sum of products? > > 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] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
