Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Use Sum(If(Goods='Cloths',Amount))
Thanks a lot!
Just a small point - avoid using 'if' wherever possible as it has a perfomance overhead particularily with large amounts of data.
This should be more efficient:
sum(pick(match(Goods,'Cloths'), Amount))
Regrads,
Gordon