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

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.

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.