Good Day,
I have a spreadsheet where we record what sites we need to complete along with a tech and completed date.
What im trying to do is if a site is completed, to add up how many sites that specific tech has done to date.
So basically check if cell C2 has a value then add it to the tech in cell D2 and run down the 2 columns to get a total value for the tech which will be output to H12,H13 etc
Any assistance would be greatly appreciated.
I have a spreadsheet where we record what sites we need to complete along with a tech and completed date.
What im trying to do is if a site is completed, to add up how many sites that specific tech has done to date.
So basically check if cell C2 has a value then add it to the tech in cell D2 and run down the 2 columns to get a total value for the tech which will be output to H12,H13 etc
Any assistance would be greatly appreciated.
| example.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | Site Name | Scheduled Date | Completed Date | Resource | ||||||
| 2 | Site 1 | 9/25/2021 | 5/7/2022 | MAITSH | ||||||
| 3 | Site 2 | 9/25/2021 | ||||||||
| 4 | Site 3 | 1/25/2022 | GAMMA | |||||||
| 5 | Site 4 | 5/7/2022 | 5/7/2022 | GAMMA | Resource Count | |||||
| 6 | Site 5 | 11/5/2022 | MAITSH | 3 | ||||||
| 7 | Site 6 | 2/23/2022 | GRALOW | GAMMA | 3 | |||||
| 8 | Site 7 | 9/1/2022 | 5/7/2022 | MAITSH | GRALOW | 2 | ||||
| 9 | Site 8 | 4/21/2022 | MAITSH | |||||||
| 10 | Site 9 | 9/1/2022 | 5/7/2022 | GRALOW | ||||||
| 11 | Site 10 | 11/18/2022 | Completed Sites | |||||||
| 12 | Site 11 | 3/29/2022 | MAITSH | ? | ||||||
| 13 | Site 12 | 3/6/2022 | GAMMA | ? | ||||||
| 14 | Site 13 | 8/24/2022 | GAMMA | GRALOW | ? | |||||
Sheet1 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| H6:H8 | H6 | =COUNTIF(D:D,G6) |
