SUMPRODUCT function - Microsoft Support
In this example, we'll use SUMPRODUCT to return the total sales for a given item and size: SUMPRODUCT matches all instances of Item Y/Size M and sums them, so for this example 21 plus 41 equals 62. To use the default operation (multiplication): =SUMPRODUCT (array1, [array2], [array3], ...) The SUMPRODUCT function syntax has the following arguments:
Excel functions (by category) - Microsoft Support
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column. Version markers indicate the version of Excel a function was introduced.
Customize a parameter query - Microsoft Support
You can customize a Microsoft Query parameter query by changing the prompt, by using data from a cell as the prompt, or by using a constant.
Sign in to Office - Microsoft Support
Sign in to www.office.com from a web browser and start using the apps on the web or access other web services associated with your account such as OneDrive. 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.