| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum text cells with number cells?
I am trying to sum a range of cells with money with a range of cell's with a
name. For example, I want to find all the cell's with the name Lange's in it and have it sum the total's for what I spent at Lange's. I've tried SUMIF but it didn't seem to work...Please help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sum text cells with number cells?
It would seem that the SUMIF function would do the job, but unless you post
your formula, we won't know what issues you're facing. *********** Regards, Ron XL2002, WinXP-Pro "meliswi3" wrote: I am trying to sum a range of cells with money with a range of cell's with a name. For example, I want to find all the cell's with the name Lange's in it and have it sum the total's for what I spent at Lange's. I've tried SUMIF but it didn't seem to work...Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
