Blank Cells vs. Zero Values
 

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

Blank Cells vs. Zero Values
 

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
---------------
Jacob Skaria


"bob" wrote:

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

Blank Cells vs. Zero Values
 

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