| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif function does not add up cells, even when criteria is blank
Beckster
Sounds like the numbers are actually "text". Re-formatting to numbers will not do the trick. Select an empty cell formatted as General and copy. Select your range of "numbers" and Paste SpecialAddOKEsc. This will force the numbers to be numbers. Gord Dibben MS Excel MVP On Fri, 13 Jan 2006 01:40:02 -0800, "Beckster" wrote: I have a range of cells which retrurn a value if I use the Sum function. They are all formatted as numbers. However if I use Sumif it always returns zero, even if I leave the criteria blank to sum all cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Sumif function with multiple criteria | Excel Worksheet Functions | |||
| SumIF function | Excel Discussion (Misc queries) | |||
| Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
| IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
Threaded Mode
