When I tried using Autosum and just selecting the ranges like I do normally it gave me the #VALUE error
Help? There's got to be a way to do this.

Thank you!!