S
Steved
Hello from Steved
Below is my attempt and it does what it is designed to do.
Question is there away please to Shorten the formula, Thanks.
=SUM(IF(Kilometres!$C$6:$C$2000={"SG220","SG242"},IF(Kilometres!$D$6:$D$2000="SHORE
DEPOT",Kilometres!$G$6:$G$2000,0),0))+SUM(IF(Kilometres!$C$6:$C$2000={"SG220","SG242"},IF(Kilometres!$D$6:$D$2000="OREWA
DEPOT",Kilometres!$G$6:$G$2000,0),0))
Below is my attempt and it does what it is designed to do.
Question is there away please to Shorten the formula, Thanks.
=SUM(IF(Kilometres!$C$6:$C$2000={"SG220","SG242"},IF(Kilometres!$D$6:$D$2000="SHORE
DEPOT",Kilometres!$G$6:$G$2000,0),0))+SUM(IF(Kilometres!$C$6:$C$2000={"SG220","SG242"},IF(Kilometres!$D$6:$D$2000="OREWA
DEPOT",Kilometres!$G$6:$G$2000,0),0))