Blank Cells vs. Zero Values

  • Thread starter Thread starter bob
  • Start date Start date
B

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
 
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
 
Back
Top