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

Maybe...

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


wrote:

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

Copy your formula here so that somebody can offer a solution

" wrote:

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