| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumproduct ... Empty Cells vs Spaces?
Excel 2000 ... I have data I copy/paste to Excel from an
Access query (I know nothing about Access so I munipulate data in Excel) ... My data consist of 40 columns by 10,000 rows. I am using SUMPRODUCT to compare data in 6 Columns (you just gotta love this function). 3 Columns contain all data while the other 3 Columns contain Data &/or empty cells or cells with "spaces" ... (at least I assume "spaces" because they appear empty, but are not empty.) Above said ... I want SUMPRODUCT to only be TRUE when there is data in all 6 Columns ... So, how do I best write SUMPRODUCT formula to accommodate conditions for those 3 Columns that contain data, &/or empty cells &/or "spaces"? Thanks ... I am really enjoying the benefits of this function ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| empty cells in ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
