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]
