Forum Discussion

CrisO655's avatar
CrisO655
Copper Contributor
Dec 12, 2023

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(...