Try this...

=SUMIF(Chart1!$AZ$2:$AZ$10000,0,Chart1!$F$2:$F$100 00)

--
Biff
Microsoft Excel MVP


"bob" wrote in message
...
Column AZ contains cells that are either zero or are blank (meaning no
value
has been entered in the cell). The formula below is referencing the blank
cells as zeroes. But I only want it to reference the cells that have zero
in
them. How do I modify the formula so it ignores the blank cells?

{SUM(IF(Chart1!$AZ$2:$AZ$10000=0,Chart1!$F$2:$F$10 000),)}


Thanks,
Bob