COUNTIF function - Microsoft Support
WEBUse COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)
Ways to count values in a worksheet - Microsoft Support
WEBYou can count the number of values in a range or table by using a simple formula, clicking a button, or by using a worksheet function. Excel can also display the count of the number of selected cells on the Excel status bar.
Overview of formulas in Excel - Microsoft Support
WEBIf you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
IF function - Microsoft Support
WEBIF function. The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Excel functions (by category) - Microsoft Support
WEBCOUNT function. Counts how many numbers are in the list of arguments. COUNTA function. Counts how many values are in the list of arguments. COUNTBLANK function. Counts the number of blank cells within a range. COUNTIF function. Counts the number of cells within a range that meet the given criteria. COUNTIFS function
Statistical functions (reference) - Microsoft Support
WEBCOUNT function. Counts how many numbers are in the list of arguments. COUNTA function. Counts how many values are in the list of arguments. COUNTBLANK function. Counts the number of blank cells within a range. COUNTIF function. Counts the number of cells within a range that meet the given criteria. COUNTIFS function
Examples of common formulas in lists - Microsoft Support
WEBYou can use the following formulas to perform a variety of mathematical calculations, such as adding, subtracting, multiplying, and dividing numbers, calculating the average or median of numbers, rounding a number, and counting values.
COUNTIFS function - Microsoft Support
WEBHow to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.
VLOOKUP function - Microsoft Support
WEBHLOOKUP function. Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Use a formula in a Word or Outlook table - Microsoft Support
WEBYou can perform calculations and logical comparisons in a table by using formulas. The Formula command is found on the Table Tools , Layout tab, in the Data group. A formula in Word automatically updates when you open the document that contains the formula.