get that 0 outta there

[dlotz]

I am runnings SUMPRODUCT funciton that
<> a date range and then produce a code

SO there is a date entry in one cell and emp # in another cell.

I all I want to is adjust my formula for if there is no data in the two
cell it will not produce a 0, for sorting purposes

 

[Dave Peterson]

Maybe...

=if(sumproduct(...)=0,"",sumproduct(...))

 

[Ron@Buy]

Copy your formula here so that somebody can offer a solution