Spreadsheet: 721727d1614845247-returning-percentage-complete-of-an-activity-by-searching-multiple-criteria-activity-percentage
Sheet: Activities

 |  | Activity ID | Item No. |  |  |  |  |  |  |  |  |  |  | Completed
 |  | 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 |  |  |  |  |  |  |  |  |  |  | 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 | 1 |  |  |  |  |  |  |  |  |  |  | 1