Someday people will learn that long sheet names really do suck! <vbg

Biff

"Steved" wrote in message
...
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.