I thankyou Both.

"Roy" wrote:

I usually do it with an IF test like this...

=IF(SUMPRODUCT(('Planned Kilometres'!$A$4:$A$109=1)*('Planned
Kilometres'!$B$4:$B$109="P")*'Planned
Kilometres'!$AC$4:$AF$109)=0,"",SUMPRODUCT(('Plann ed
Kilometres'!$A$4:$A$109=1)*('Planned Kilometres'!$B$4:$B$109="P")*'Planned
Kilometres'!$AC$4:$AF$109))

Roy
"Steved" wrote:

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.