dracula cyrus
New Member
- Joined
- Nov 30, 2021
- Messages
- 5
- Office Version
- 365
- 2021
- Platform
- Windows
Hi all,
I've been trying to find a code to save my time from the calculation. This would save me plenty of time and hope anyone out there would assist me with this.
In the attached picture.. I am trying to search for a specific name from each date WHILE ignoring the time and match to those names in $W:$W. After which, I'll want to take the value in the cell beside and sum them in cell X, right beside the specific name.
For example.. Looking into ($K:$K, $N:$N, $Q:$Q, $T:$T = W6), where W6 is Garrett. I would want to find all the cells that have the word 'Garrett' but ignore other details within the same cell and take the value on the right to sum it up in X6. This is why Garrett is $60 for the date between 4-7 Jan.
I've been trying to find a code to save my time from the calculation. This would save me plenty of time and hope anyone out there would assist me with this.
In the attached picture.. I am trying to search for a specific name from each date WHILE ignoring the time and match to those names in $W:$W. After which, I'll want to take the value in the cell beside and sum them in cell X, right beside the specific name.
For example.. Looking into ($K:$K, $N:$N, $Q:$Q, $T:$T = W6), where W6 is Garrett. I would want to find all the cells that have the word 'Garrett' but ignore other details within the same cell and take the value on the right to sum it up in X6. This is why Garrett is $60 for the date between 4-7 Jan.