SUMIF function - Microsoft Support
You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5.
Filter by using advanced criteria - Microsoft Support
Filter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.
Manage workbook links - Microsoft Support
Create a workbook link. Description of workbook link management and storage in Excel. Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.
Sign in to Office - Microsoft Support
How you sign in to an installed Office app depends on your device. Tip: To add an email account to Outlook or for help signing into Outlook.com, see Outlook help & learning. Select your device for more detailed sign in steps: