| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sumproduct with text and numbers in cells
Excel 2007
I want to sum a column that each cell has a number or text in it based on the conditions of that cell having a number and the results of other arrays. I keep getting #value error even though I use the double unary (--). Can I do this using sumproduct or do I need to use the sumifs? I was hoping to use the sumproduct to keep the workbook compatible with 2003 user. Thanks, -- Lee Coleman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct Numbers and Text? | New Users to Excel | |||
| Summing cells that contain numbers and text | Excel Discussion (Misc queries) | |||
| How do I sum numbers in cells that have text? | Excel Worksheet Functions | |||
| Cells as text not numbers??? | Excel Discussion (Misc queries) | |||
| How do I sum numbers from cells that contain text | Excel Worksheet Functions | |||
Threaded Mode
