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

  • Thread starter Thread starter Steved
  • Start date Start date
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.
 
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))}
 
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))}
 
Hello from Steved

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

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