ANTONIO1981
Board Regular
- Joined
- Apr 21, 2014
- Messages
- 162
HI ALL
Is there a way to simplify this formulae
=SUMIFS(R_conveyor_table!$D:$D,R_conveyor_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_vacuum_table!$C:$C,R_vacuum_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_Jetwash_table!$C:$C,R_Jetwash_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(PROMO_Table!$C:$C,PROMO_Table!$B:$B,'COUNTRY P&L'!D$6)
make it shorter and clearer?
thanks in advance
Anthony
Is there a way to simplify this formulae
=SUMIFS(R_conveyor_table!$D:$D,R_conveyor_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_vacuum_table!$C:$C,R_vacuum_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(R_Jetwash_table!$C:$C,R_Jetwash_table!$B:$B,'COUNTRY P&L'!D$6)+SUMIFS(PROMO_Table!$C:$C,PROMO_Table!$B:$B,'COUNTRY P&L'!D$6)
make it shorter and clearer?
thanks in advance
Anthony
