In column B:B and D:D I've a Formula

S

Steved

Hello from Steved

Ok Column D:D finds CITY DEPOT

once found add CITY DEPOT Kilometres in Column B:B

What is needed please to acheive adding Kilometres in Column B:B the below
is not working and I don't know what is wrong yes Columns B:B and D:D have
formulas.

=SUM(($D$2:$D$3000="CITY DEPOT")*$B$2:$B$3000)
{=SUM(($D$2:$D$3000="CITY DEPOT")*$B$2:$B$3000)}

Thankyou.
 
S

Steved

Hello from Steved

I Thankyou but I'm getting #VALUE! by using your formula

=SUMPRODUCT(($D$2:$D$3000="CITY DEPOT")*($B$2:$B$3000))
And also I did this.
{=SUMPRODUCT(($D$2:$D$3000="CITY DEPOT")*($B$2:$B$3000))}

The below is in Column B:B
{=IF(ISNA(VLOOKUP(A2,'Auckland
Kilometres'!$A$2:$G$1977,7,FALSE)),"0",VLOOKUP(A2,'Auckland
Kilometres'!$A$2:$G$1977,7,FALSE))}


The below is in Column D:D
{=IF(ISNA(VLOOKUP(A2,'Auckland Kilometres'!$A$5:$E$4952,4,FALSE)),"Out Of
Service",VLOOKUP(A2,'Auckland Kilometres'!$A$5:$E$4952,4,FALSE))}
 
S

Steved

Hello from Steved

Thankyou I had another look and foun that a couple off the formulas were the
problem alls well
 

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

Similar Threads


Top