| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SubTotal for Sum function returning zeros
I have a data table ( originally pulled from another spreadsheet using SQL
query - probably irrelevant to the issue ). When I try to SubTotal with the sum function it incorrectly returns zero for all results. The cell formats are number. Any idea what's going on here ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SubTotal for Sum function returning zeros
Post your formula and your expectation
"ForestFeeder" wrote: I have a data table ( originally pulled from another spreadsheet using SQL query - probably irrelevant to the issue ). When I try to SubTotal with the sum function it incorrectly returns zero for all results. The cell formats are number. Any idea what's going on here ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SubTotal for Sum function returning zeros
It seems that the data IS IN FACT text, even though the properties of the
cells are number! I confirmed this by copying a row to another worksheet. The data pasted as text. It did inform me as a warning in the pasted row that the data was stored as text. So, how can I truly set the data to NUMBER ? P.S. the formula is =SUBTOTAL(9,E6:E8) "Teethless mama" wrote: Post your formula and your expectation "ForestFeeder" wrote: I have a data table ( originally pulled from another spreadsheet using SQL query - probably irrelevant to the issue ). When I try to SubTotal with the sum function it incorrectly returns zero for all results. The cell formats are number. Any idea what's going on here ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SubTotal Function | Excel Discussion (Misc queries) | |||
| Min function without zeros | Excel Discussion (Misc queries) | |||
| subtotal function | New Users to Excel | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Hybrid Mode
