Combine 2 formulasinto 1.
 

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.

Combine 2 formulasinto 1.
 

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

"Steved" wrote in message
...
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.

Combine 2 formulasinto 1.
 

Thanks Biff

"Biff" wrote:

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

"Steved" wrote in message
...
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.