Hi, welcome to the forum

1. in your SP formulas, are you using full column ranges? (A:A etc) If so, change them to cover just the ranges you need...A1:A400
2. Have you considered using some of the other, more efficient functions excel 2010 provides?
- sumif/sumifS
- countif/countifS
- averageif/averageifS
(among others)

Can you provide a few samples of your SP formulas, or, better yet, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.