3 Replies Latest reply: Jan 10, 2012 5:19 AM by Gordon Savage RSS

    Straight Table: sum(amount) when condition is fulfilled...

      Hello,

       

      I'm making a straight table with a sum of purchases shown for each month. This first column is for cloths, the next for household goods etc...

       

      making the sum is not difficult: Sum(amount) but when I add an 'if' so I only include items that are cloths (for example Goods='cloths') the result is always zero.

       

      Whats wrong with this statement as expression:

       

      =if(Goods='Cloths',sum(Amount),0)

       

      What should be changed?