Using a conditional sumif which allows a cell name as one of the criteria

[Dan]

I am wanting to use this same spreadsheet month to month
and be able to have a cell named SelectMonth which has a
list of months the same as the column month. To update
the MIS on the second tab (DOC) I would merely select the
month I want and it would produce the information on the
DOC tab for that specific month only. Our MIS report on
our main system runs month to month and I use this report
to reconcile against the accounting entries, but want to
be able to use the sheet OffGr to quickly track sales
history for any given period eg How many F150 have been
sold since the first of the year and what is the average
gross. If I have to use a separate file for each month
then I will have to cut and paste the infomation. I know
there has to be a way to do this I just don't know how.
Here is the statement I am using but cannot get it to
allow a cell name to be used which would be selectable.
{=SUM(IF(OffGr!$E$2:$E$100="F150",IF('Office Gross Sheet
Mar 04.xls'!Adj<>"A",OffGr!$F$2:$F$100,0),0))}
Any suggestions

 

[Frank Kabel]

Hi Dan
not quite sure but you may have a look at the INDIRECT function