Try: =SUMPRODUCT((B3:B296<"")*(C3:C296<"")*(D3:D296=0 ))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lesg46" wrote:
I have tried looking up other peoples questions, but they only want to count
the number that arent 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.

Ive 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, Id be forever grateful. I have 35 sales people to do
this for, on a rolling basis, all year!

Thanks in advance
Lesg46