| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Statement Question 0 values & blank cells
Here is my formula:
IF(SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*($ B$3:$E$5))="","", SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*($B$3 :$E$5))) I get a 0 value for a blank cell.. I would like nothing returned for a blank cell. If I use =0, "", I will not receive a value for cells that have a 0 in them. Help! Thanks, Josh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Threaded Mode
