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.
Bookmarks