Sum values based on multiple conditions - Microsoft Support
Sum values based on multiple conditions. Applies To. Let's say that you need to sum values with more than one condition, such as the sum of product sales in a specific region. This is a good case for using the SUMIFS function in a formula.
How to correct a #N/A error - Microsoft Support
The most common cause of the #N/A error is with XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can’t find a referenced value. For example, your lookup value doesn’t exist in the source data. In this case there is no “Banana” listed in the lookup table, so VLOOKUP returns a #N/A error.
Improve accessibility with the Accessibility Checker
Before you send an Outlook email message or share a Word document, Excelspreadsheet, PowerPoint presentation, or OneNote notebook, run the Accessibility Checker to make your content easier for people to read and edit.
Create a Venn diagram - Microsoft Support
A Venn diagram uses overlapping circles to illustrate the similarities, differences, and relationships between concepts, ideas, categories, or groups. Similarities between groups are represented in the overlapping portions of the circles, while differences are represented in the non-overlapping portions of the circles.