Originally Posted by Spencer101
Depending on which version of Excel you're running, you can do this with SUMPRODUCT or SUMIFS.
Although as you have a worksheet for each month a summary worksheet would make things easier.
Happy to help you set this up if you can provide an example workbook.
I've got 2010. Here's the file, hopefully the attachment worked. I had to do a zip.