What does not working mean?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mmb" wrote in message
...
Jon, Thank you, but it is not working.

"Jon Peltier" wrote:

Change the zeros in the formula to NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mmb" wrote in message
...
Here is my formula, When i creat my chart it shows all the blanks or 0
data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))