Spreadsheet: 721732d1614845929-returning-percentage-complete-of-an-activity-by-searching-multiple-criteria-activity-percentage
Sheet: Activities

 |  | Activity ID | Item No. |  |  |  |  |  |  |  |  |  |  | Completed
 |  | XXX.BLK | 2 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BLK | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  | XXX.BCS | 1 |  |  |  |  |  |  |  |  |  |  | 0
 |  | XXX.BCS | 2 |  |  |  |  |  |  |  |  |  |  | 1