Sumproduct & Search specific word

[dracula cyrus]

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.

 

[Fluff]

Duplicate to: Google Sheet; sumproduct + search

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.