S
Steved
Hello from Steved
If the cell has an 0 as a value what is required please to make it blank.
=SUMPRODUCT(('Planned Kilometres'!$A$4:$A$109=1)*('Planned
Kilometres'!$B$4:$B$109="P")*'Planned Kilometres'!$AC$4:$AF$109).
Thankyou.
If the cell has an 0 as a value what is required please to make it blank.
=SUMPRODUCT(('Planned Kilometres'!$A$4:$A$109=1)*('Planned
Kilometres'!$B$4:$B$109="P")*'Planned Kilometres'!$AC$4:$AF$109).
Thankyou.