Combine 2 formulasinto 1.

[Guest]

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.

 

[Biff]

Hi!

Put all these variables in a list somewhere,say, A1:A5

82MAN-SG220
83MAN-SG220
88MAN-SG240
89MAN-SG240
90MAN-SG240

These also,say, B1:B2

City Depot
Roskill Depot

Normally entered:

=SUMPRODUCT(--(ISNUMBER(MATCH(Kilometres!$D$1:$D$4999,A1:A5,0))),--(ISNUMBER(MATCH(Kilometres!$E$1:$E$4999,B1:B2,0))),Kilometres!$C$1:$C$4999)

Biff

 

[Guest]

Thanks Biff

Hi!

Put all these variables in a list somewhere,say, A1:A5

82MAN-SG220
83MAN-SG220
88MAN-SG240
89MAN-SG240
90MAN-SG240

These also,say, B1:B2

City Depot
Roskill Depot

Normally entered:

=SUMPRODUCT(--(ISNUMBER(MATCH(Kilometres!$D$1:$D$4999,A1:A5,0))),--(ISNUMBER(MATCH(Kilometres!$E$1:$E$4999,B1:B2,0))),Kilometres!$C$1:$C$4999)

Biff