Hello, I have a problem with 'conditional sum' (as it was called in Excel). I believe it's SUM.IF in OOo. I'm spoiled by the way Excel led me through the motions, and don't quite succeed in doing the same in OOo. The idea is that when in the sheet 'journaal' two conditions are met in a range of cells in columns C and D, the amounts in the corresponding cells in column H will be summed in the result cell in another (second) sheet This is how OOo translated the formula made in the Excel sheet =SOM(ALS($journaal.$C$2:$C$179="nau";ALS($journaal.$D$2:$D$179="zek";$journaal.$H$2:$H$179;0);0)) (SOM.ALS is dutch for SUM.IF) I don't find an easy way to produce such formula in OOo. One condition (C="nau") is OK with Insert>Function, but do I have to add the second condition (D="zek") manually? This is what I get: =SOM.ALS(journaal.C2:C179;"sec";journaal.G2:G173)
Thanks, -- Guy using dutch OOo Aqua 3.0.0 Beta-2 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 Beta-2 on an Intel MacBook Pro Leopard -- please reply only to [email protected] -- Dodoes can't afford to have headaches
