Blank Cells vs. Zero Values

[bob]

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$10000),)}


Thanks,
Bob

 

[Jacob Skaria]

Array entered
=SUM(IF(Chart1!$AZ$2:$AZ$10000<>"",IF(Chart1!$AZ$2:$AZ$10000=0,
Chart1!$F$2:$F$10000)))

If this post helps click Yes

 

[T. Valko]

Try this...

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