S
Steved
Hello from Steved
Ok Column 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 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.
Ok Column 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 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.