Spreadsheet: 805109d1668531075-formula-showing-totals-from-multiple-sources-excel-forum-example-2
Sheet: SITE

Name | Status | Notes | Yes or No? | Yes or No? | Yes or No? | Yes or No? | Yes or No? | Yes or No? | Yes or No? | Yes or No? | Yes or No? | [NAME] | [NAME] | [NAME] | [NAME] | Info 5 | Email address | Role
Name 1 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 2 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 3 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 4 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 5 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | No | NA |  |  |  |  |  |  | [EMAIL] | Contractor
Name 6 | Completed | Bla, bla, [NAME]… | Yes | No |  |  | Yes | Yes | N/A | No |  |  |  |  |  |  | [EMAIL] | Contractor
Name 7 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 8 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 9 | Ongoing | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 10 | Completed | Bla, bla, [NAME]… | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 11 | Do Not Contact | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 12 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 13 | Completed | Bla, bla, [NAME]… | Yes | Yes | N/A | N/A | Yes | Yes | Yes | Yes | Yes |  |  |  |  |  | [EMAIL] | Contractor
Name 14 | Ongoing | Bla, bla, [NAME]… | No | Yes |  | Yes | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 15 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 16 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 17 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 18 | Ongoing | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 19 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Staff
Name 20 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 21 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 22 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Staff
Name 23 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 24 | Do Not Contact | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 25 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | No |  |  |  |  |  |  | [EMAIL] | Contractor
Name 26 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | No |  |  |  |  |  |  | [EMAIL] | Contractor
Name 27 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 28 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 29 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 30 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | N/A | N/A |  |  |  |  |  |  | [EMAIL] | Contractor
Name 31 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 32 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Staff
Name 33 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 34 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 35 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 36 | Completed | Bla, bla, [NAME]… | Yes | Yes | Yes |  | Yes | Yes | Yes |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 37 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 38 | OOO | Bla, bla, [NAME]… | no | ? | Yes | ? | no | yes | yes | ? |  |  |  |  |  |  | [EMAIL] | Staff
Name 39 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 40 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 41 | Rebook | Bla, bla, [NAME]… |  |  | Yes | Yes | Yes | Yes | Yes |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 42 | Completed | Bla, bla, [NAME]… | yes | yes | yes | yes | yes | yes | yes | yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 43 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 44 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 45 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Staff
Name 46 | Booked | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 47 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 48 | Booked | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 49 | Completed | Bla, bla, [NAME]… | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 50 | Ongoing | Bla, bla, [NAME]… | No | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 51 | No Response | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 52 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 53 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 54 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 55 | Ongoing | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 56 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | No(using own McAffe) | No |  |  |  |  |  |  | [EMAIL] | Contractor
Name 57 | Rebook | Bla, bla, [NAME]… |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 58 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 59 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor
Name 60 | Completed | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Staff
Name 61 | Completed | Bla, bla, [NAME]… | Yes | Yes |  |  | Yes | Yes | Yes | No |  |  |  |  |  |  | [EMAIL] | Contractor
Name 62 | Rebook | Bla, bla, [NAME]… |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL] | Contractor
Name 63 | Ongoing | Bla, bla, [NAME]… | No | Yes |  |  | Yes | No | Yes | Yes |  |  |  |  |  |  | [EMAIL] | Contractor