Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotaling on column with IF statement results
I created a spreadsheet with one column having an IF statement - it
calculates how much we should re-order per store based on what was sold. I asked it to subtotal for each store - the formula appears in the cell, but it does not calculate the subtotal. I tried saving the column as the values, but it still does not subtotal. When I typed in the numbers, it DID subtotal. What do I need to do so it will subtotal? Thanks for your help. -- STK |
#2
|
|||
|
|||
By any chance are you importing the data from another application?
Check out your numbers: does the cell contain an apostrophe and then the number? This happens sometimes: if you are importing, and this is the case, you may be able to adjust the output side of the other application to avoid the apostrophe. As a workaround for now, try this formula: =--SUBSTITUTE(A1,"*","") This should convert whatever is in your cell currently to a numeric value. You can then copy the formula, and paste it as values over the existing data. |
#3
|
|||
|
|||
Thanks, the substitution works. The initial spreadsheet was created in a
customer's database and we exported it to Excel. There is no apostrophe in the cell. I created the IF statement in a macro and used it for the next spreadsheet we received from the vendor. "Dave O" wrote: By any chance are you importing the data from another application? Check out your numbers: does the cell contain an apostrophe and then the number? This happens sometimes: if you are importing, and this is the case, you may be able to adjust the output side of the other application to avoid the apostrophe. As a workaround for now, try this formula: =--SUBSTITUTE(A1,"*","") This should convert whatever is in your cell currently to a numeric value. You can then copy the formula, and paste it as values over the existing data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table results - with value in every row and column | Excel Discussion (Misc queries) | |||
Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
i am using an if statement to sum a row with a column and i'm off. | Excel Worksheet Functions | |||
adding if statement results | Excel Worksheet Functions |