Forum Discussion
CrisO655
Dec 12, 2023Copper Contributor
I need an XLOOKUP formula
I wish for a formula to find to find a word in one column AND a word in another column and the sum all the values in a third column that relate to both words.
I have tried nesting xlookups: =SUM(XLOOKUP(D451,E:E,XLOOKUP(B451,B:B,Z:Z)))
- Patrick2788Silver ContributorHave you considered using SUMIFS?