0 to be blank please

[Steved]

Hello from Steved

What is required please if value is 0 the cell
to be blank.

=SUMPRODUCT(--($D$1:$D$800="City"),--(TRIM($C$1:$C$800)
="305"))

Thanks.

 

[Guest]

In format cell dialog box Set the format to custom and type
to #

 

[Steved]

Thankyou very much.

-----Original Message-----
In format cell dialog box Set the format to custom and type
to #



.

 

[PAR]

No problem, got any ideas for me? Need to reference
multiple cells in if statement.

 

[Steved]

Sorry Par but I cannot understand the concepts.

I had a look but it is beyond my ability.