This content has been marked as final.
Show 2 replies

Re: sum for conditional use of formula in graph
Stefan Wühl Jun 25, 2012 7:34 PM (in response to Robert Zeliznak)Try this
=sum(if(LArt='LDUB15',0, if(LEFT(LArt,4)='LDUB',Price*Volume/1000, Volume*Price*100)))
i.e. embedding the condition into the sum, not the sum into the condition.

Re: sum for conditional use of formula in graph
Robert Zeliznak Jun 26, 2012 2:41 AM (in response to Stefan Wühl )Hi Swuehl,
thanks for help.
I have tried to use this logic before, even more times, but allways got the "Error in expression". Originaly I have more IFs in expression then in my example, therfore migt be I have forgotten to delete something...
Thanks again.
Robert
