Summurising to Depots

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))
 
D

Domenic

Try...

=SUM(IF(ISNUMBER(MATCH(Kilometres!$C$6:$C$2000,{"SG220","SG242"},0)),IF(I
SNUMBER(MATCH(Kilometres!$D$6:$D$2000,{"SHORE DEPOT","OREWA
DEPOT"},0)),Kilometres!$G$6:$G$2000)))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
S

Steved

Thankyou.

Domenic said:
Try...

=SUM(IF(ISNUMBER(MATCH(Kilometres!$C$6:$C$2000,{"SG220","SG242"},0)),IF(I
SNUMBER(MATCH(Kilometres!$D$6:$D$2000,{"SHORE DEPOT","OREWA
DEPOT"},0)),Kilometres!$G$6:$G$2000)))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 

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