Sumifs question.

I have a general question. I am trying to use sumifs to read a spreadsheet. I am writing the formula on one worksheet and trying to pull the criteria from another worksheet. Here is my formula =SUMIFS(T5.0M!D2:D51,T5.0M!B2:B51,T5.0M!B2:B51,T5.0M!C2:C51,T5.0M!C2:C51) . My problem is for criteria 1 and 2 I want to seach through a range to find a particular name. Example: "Thomas" may be in A5 and A9 I want to use the cell reference and not thomas to seach the whole row. Please help.

I'm not sure I understand, do you mean you want to sum for multiple names or just a single name? You can use a cell ref for the criteria like

=SUMIFS(T5.0M!D2:D51,T5.0M!B2:B51,Z1,T5.0M!C2:C51,Z2)

where your criteria are in Z1 and Z2......but I suspect you want something different....