Sum items based on user specified month range

**amg03d** · 05-28-2010, 10:58 AM

I have multiple sheets that are in the same format with monthly information.

http://i1041.photobucket.com/albums/...ateexample.png

I want to use the summary sheet below to allow a user to input a month range and allow them to see the sum of each of the different labeled totals, and if a particular location (sheet) in the group does not go up to the certain month specified than I want that specific location to not display its information and say 'not enough data' for example. The sums that I want taken from the different sheets are in rows 15-26, because the other rows of information are calculations based on these sums and obviously require simple mathematical equations. BUT, for row 7 that is a cell that must be defined as the value of a cell 6 months prior to the end of the range taken from row 8 of the ABOVE templates.

http://i1041.photobucket.com/albums/...teexample2.png

Anyone know how to approach this? I appreciate any input.

**amg03d** · 05-28-2010, 10:59 AM

I can add more info if necessary

**amg03d** · 05-28-2010, 11:06 AM

bump bump bump

**Dulanic** · 05-28-2010, 11:28 AM

Pictures don't really let us work with the data. Can you please attach a worksheet? With dummy data if needed. Oh and please don't bump a thread more than once a day.

**amg03d** · 05-28-2010, 11:41 AM

Originally Posted by Dulanic

Pictures don't really let us work with the data. Can you please attach a worksheet? With dummy data if needed. Oh and please don't bump a thread more than once a day.

here is an example of my workbook, thanks for the reply