Combine 2 formulasinto 1.

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.
 
B

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
 
S

Steved

Thanks Biff

Biff said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top