Copilot in Excel debuts two new complex formulas to manage multiple tables

The new functions will be added by the end of April.

Reading time icon 2 min. read

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

copilot excel

It’s been a while since Copilot made its introduction in Excel, but Microsoft has made sure to update the AI tool regularly, with useful features.

Some of these features are the addition of formulas to Copilot that make the AI tool comprehend, edit, and come up with complex solutions to manage data from dozens of tables, effectively enhancing productivity, and coming up with solutions to a variety of inputs.

A couple of new formulas are slated to be added to Copilot in Excel this month, according to the latest entry in the Microsoft 365 Roadmap. Copilot will support the XLOOKUP and SUMIF formulas which allow the AI model to look up for certain data faster, and sum it up according to the input received from users.

The XLOOKUP function is used in Excel to find things in a table or range by row. The SUMIF function is used to sum the values in a range that meets the criteria that users specify. Copilot will now be able to use these functions.

Utilize complex formulas such as XLOOKUP and SUMIF to create formula columns bringing together data from multiple tables.


The two functions should be available to use by the end of the month, according to the roadmap. However, if you haven’t tried Copilot in Excel yet, maybe this is the sign to do it. We have a comprehensive guide on everything you need to know to start using it.

You can use it to ease your work, but if you don’t know where to start, here are 4 ways you can use this AI assistant.

You can edit, create tables, ask Copilot to validate and verify data, and even retrieve data from you from other platforms, such as Word, or PowerPoint. The AI assistant can also be used to summarize information, and in Excel that can be quite useful in reports.

Microsoft is also releasing a Copilot Adoption Community for organizations to teach their employees how to use Copilot at work. If you haven’t used it before, maybe you should wait until your organization opens up the community.

More about the topics: Copilot, Excel