| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graphing 0 values from blank cells | Excel Discussion (Misc queries) | |||
| Sum of unique values within a range with blank cells | Excel Worksheet Functions | |||
| If certain cells not blank, and cells in range are, set values to | Excel Discussion (Misc queries) | |||
| blank cells plot as zero values | Charts and Charting in Excel | |||
| How to blank out cells with duplicate values? | Excel Discussion (Misc queries) | |||
Hybrid Mode
