drewcarpenter
New Member
- Joined
- Jul 19, 2010
- Messages
- 7
I have a project tasklist contained in a workbook, where the summary sheet is named "Master", and subsequent tabs are named for responsible parties, X, XX, and XXX. Tabs are bracketed by hidden sheets ("First" and "Last"). Each task has a unique identifying number in Column B and, in column I, each responsible party will be able to update their task completion %.
What I need is a formula on the master sheet that extracts the max value of all entries for a given task (each task will be in a different row depending on whose sheet it appears upon).
For Row2 of Master spreadsheet, my formula currently is: =SUMPRODUCT((THREED(First:Last!B$1:B$600)=B2)+0,(THREED(First:Last!I$1:I$600)))
The problem is that this sums all %s entered, instead of selecting the largest, but I am having a hard time trying to use MAX to extract the values... help????
What I need is a formula on the master sheet that extracts the max value of all entries for a given task (each task will be in a different row depending on whose sheet it appears upon).
For Row2 of Master spreadsheet, my formula currently is: =SUMPRODUCT((THREED(First:Last!B$1:B$600)=B2)+0,(THREED(First:Last!I$1:I$600)))
The problem is that this sums all %s entered, instead of selecting the largest, but I am having a hard time trying to use MAX to extract the values... help????