S
Steved
Hello from Steved
How can I please combine the below Formulas into one
=SUM(IF(Kilometres!$D$1:$D$4999={"82MAN-SG220","83MAN-SG220","88MAN-SG240","89MAN-SG240","90MAN-SG240"},IF(Kilometres!$E$1:$E$4999="City
Depot",Kilometres!$C$1:$C$4999,0),0))
=SUM(IF(Kilometres!$D$1:$D$4999={"82MAN-SG220","83MAN-SG220","88MAN-SG240","89MAN-SG240","90MAN-SG240"},IF(Kilometres!$E$1:$E$4999="Roskill
Depot",Kilometres!$C$1:$C$4999,0),0))
Thankyou.
How can I please combine the below Formulas into one
=SUM(IF(Kilometres!$D$1:$D$4999={"82MAN-SG220","83MAN-SG220","88MAN-SG240","89MAN-SG240","90MAN-SG240"},IF(Kilometres!$E$1:$E$4999="City
Depot",Kilometres!$C$1:$C$4999,0),0))
=SUM(IF(Kilometres!$D$1:$D$4999={"82MAN-SG220","83MAN-SG220","88MAN-SG240","89MAN-SG240","90MAN-SG240"},IF(Kilometres!$E$1:$E$4999="Roskill
Depot",Kilometres!$C$1:$C$4999,0),0))
Thankyou.