Originally Posted by

**ToxicWaltz** I'm not sure if an error was introduced in saving from google docs to my local, but I found that all of the calculations resulted in #NA error. Did some digging and discovered that it was due to excel calculating the main hand and offhand even though a 2H was selected. The calculations on a blank drop down box resulted in the #NA which carried through to all of the calculations across all of the spreadsheets. This same error would be introduced if any of the fields were not defined, but is easily worked around.

On sheet "EquipStats", replace the formula '=sum(C3:C40)' located in C42 with the formula '{=SUM(IF(ISNA(C3:C40),0,C3:C40))}', which nullfies the #NA errors located above. The squiggly brackets '{' and '}' represent and Control-shift-enter function, which will only work if all three buttons are pressed together when editting of the formula bar is finished. This should probably be done for all of the remaining columns.

Really really awesome job creating this spreadsheet and thank you thank you thank you. I don't know what caused the error (I'm using Excel 2010) and saved the spreadsheet to local. It doesn't appear to have the same issue in google docs so its probably something to do with that.

## Bookmarks