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(...
Patrick2788
Dec 12, 2023Silver Contributor
Have you considered using SUMIFS?