A total has been added and in this file, there shouldn't be errors generated. The missing description for the extra category has to be addressed or you will have continuing problems.

The error that you refer to occurs when a value is missing. In this workbook this can easily happen because of the massive category list along with the associated descriptions and prices.

I downloaded the other workbook offered. It had a macro in it but I don't enable macros so I couldn't trouble-shoot why there are REF errors.