Dont want to inlcude 0's in my chart
JOhn, Thank you.
"mmb" wrote:
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))
|