Ways to count values in a worksheet - Microsoft Support
You 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.
Total the data in an Excel table - Microsoft Support
Total the data in an Excel table. Newer Windows versions Newer Mac versions Web. You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column.
COUNTIF function - Microsoft Support
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.
Use AutoSum to sum numbers - Microsoft Support
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Sum values based on multiple conditions - Microsoft Support
You’ll find more in the SUMIFS function article. If you want to create a total value for just one range based on a value in another range, use the SUMIF function. Sum values based on one or more conditions by using the SUMIFS function in a formula.
Consolidate data in multiple worksheets - Microsoft Support
To summarize and report results from separate worksheets, you can consolidate data from each separate worksheet into a master worksheet.
Count the number of rows or columns in Excel - Microsoft Support
If you need a quick way to count rows that contain data, select all the cells in the first column of that data (it may not be column A). Just click the column header. The status bar, in the lower-right corner of your Excel window, will tell you the row count.
Subtotal and total fields in a PivotTable - Microsoft Support
When working with a PivotTable, you can display or hide subtotals for individual column and row fields, display or hide column and row grand totals for the entire report, and calculate the subtotals and grand totals with or without filtered items.
COUNTIF function - Microsoft Support
Use 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:
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).