L

#### lesg46

the number that arenâ€™t zero!

I need to count the number of days of zero sales up to the date I have data

for e.g. 21/4/08.

Salesperson 1

Date Product A Product B Total

18/4/08 0 0 0

19/4/08 5 1 6

20/4/08 0 0 0

21/4/08 10 4 14

22/4/08 0

23/4/08 0

etc until end of year

The Total column is a simple formula adding Prod A + B together and copied

down to the end of the year.

Iâ€™ve tried using =SUMPRODUCT(--(d3:d296<1)), but obviously this just counts

every zero value formula to the end of the year.

If anyone can help, Iâ€™d be forever grateful. I have 35 sales people to do

this for, on a rolling basis, all year!

Thanks in advance

Lesg46