This content has been marked as final. Show 9 replies
The above data is from my table. Would anyone teach me some simple techniques?
1. Sumif condition (Year = 2014, Class=Turnvover and COGS)
I have tried: sum(if(Class='Turnover' and Class='COGS',Amount)) but it is not work
2. Answer for 2013 Gross Profit
I have tried: Rangesum(Class='Turnover', Amount) - Rangesum(Class='COGS', Amount)
Can anyone correct my mistake, many thanks!