Autosum Help

[BB15]

I have an sheet where I use a formula (Column C) to determine a calculation based on a value in the adjacent column (Column B). When I autosum Column C, all whole values are left out of the autosum, only those values with decimals are summed. I've attached a short version of the sheet with 10 rows.

Column A is a manual input of what the formula should generate in Column C...it all matches up.

Column C does not autosum the same as Column A, even though the values are identical.

I've tried formatting Column C every way possible, nothing works. The only thing which works is manually typing over the "5" in column C.

Little help??

[AliGW]

The whole numbers are all text values - left-aligned in their cells - so will not be included in your autosum.

[BB15]

Is there a way to fix this in the formula so the numbers populate as integers instead of text?

[AliGW]

I can't see the formulae involved, but you could wrap them in the VALUE function:

=VALUE(your_formula)

[Q&A]

You dont need the quotation marks in the formula.

Try the following in cell C2
IF(B2<51,5,IF(AND(B2>=51,B2<=100),0.1*B2,IF(AND(B2>100,B2<201),12.5,IF(B2>200,15)))) instead of
IF(B2<51,"5",IF(AND(B2>=51,B2<=100),0.1*B2,IF(AND(B2>100,B2<201),12.5,IF(B2>200,15))))

Also be careful the of you summation in C12 its not summing all the cells above

[mike7952]

Change your formula. Remove the "5" to 5

from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[BB15]

BAM! That did it. Thanks - I love the British. And dudes from FLA

[mike7952]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.