Hi all

I am using Excel 2000

I am wanting to use the sumproduct function or something similar to resolve
the following problem.

I have a table with one product per column (colums C:H)
In Column A I have dates
In row 4 I have the selling price of each product

In the rest of the table I have client names showing which client bought
which product on which date.

What I would like to do is use the Sumproduct function or something similar
to place the total sales value on a particular day into column 'B'.

The client never buys more than one item so it can be assumed that if a cell
value is text (the clients name) then it is equal to 1 but of course there
may be more than one product sold on a particular date.

I suppose another way to explain this is that I want to use Sumproduct but
one of the sets of data is not a value but is text and unless the cell is
blank in this set of data its value is 1.

Any ideas or a solutions would be appreciated

George