7a | search
Click here to view 7a news from 60+ newspapers.
Bookmark or Share- COUNTIF function - Microsoft SupportUse 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:
- Manage workbook links - Microsoft SupportFind workbook links. There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.
- Break a link to an external reference in Excel - Microsoft SupportWhen you break a link to the source workbook of an external reference, all formulas that use the value in the source workbook are converted to their current values. Because this action cannot be undone, you may want to save a version of the destination workbook as a backup.
- Excel functions (by category) - Microsoft SupportWorksheet 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.
- Create custom functions in Excel - Microsoft SupportCertain kinds of statements, such as statements that select and format ranges, are excluded from custom functions. In this article, you’ll learn how to create and use custom functions. To create functions and macros, you work with the Visual Basic Editor (VBE), which opens in a new window separate from Excel.
More
