Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

I need an XLOOKUP formula

Copper Contributor

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)))

 

1 Reply
Have you considered using SUMIFS?