Just found this is Evernote's help:
Can I insert formulas or other spreadsheet functions into my table?
No. Tables in Evernote are optimized for the display, presentation, and visualization of information. Tables in Evernote are not optimized for manipulating data. If you use a spreadsheet program outside of Evernote, you can attach the file to your note to keep it in context with the rest of your notes.