| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum Product Function- Blank Cells
I am working with the sum production function & I can't figure out how to get
the function to return a blank cell with no data is in the specified cell. Here is the function I'm using. SUMPRODUCT((A2:A450=A7)*(B1:BG1=B6)*(B2:BG450)) Column A2- includes ID #'s, while row 1 includes dates. The data set (B2-B45) has some blank cells, & I want it to return a blank, & not a 0, however some cells have a 0, and I want the 0 to be returned. I feel I'm missing something really obvious. Any help would be greatly appreciated! Thanks, Josh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
| Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
| write a function to determine if cells have names | Excel Worksheet Functions | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| Skipping Blank Or Null Cells In a Lookup Function | Excel Worksheet Functions | |||
Threaded Mode
