I have the following formula =(MAX(0,SUMIF(K29,">40")-40))*1.5 I need to add cell X20 to K29. I have tried
=(MAX(0,SUMIF(K29,X20),">40"))-40))*1.5
=(MAX(0,SUMIF(K29+X20),">40"))-40))*1.5
=(MAX(0,SUMIF(K29,X20)">40"))-40))*1.5
=(MAX(0,SUMIF(K29+X20)">40"))-40))*1.5
But it doesn't work. What am I doing wrong?
=(MAX(0,SUMIF(K29,X20),">40"))-40))*1.5
=(MAX(0,SUMIF(K29+X20),">40"))-40))*1.5
=(MAX(0,SUMIF(K29,X20)">40"))-40))*1.5
=(MAX(0,SUMIF(K29+X20)">40"))-40))*1.5
But it doesn't work. What am I doing wrong?