From the course: Excel for Accounting
Join today to access over 25,500 courses taught by industry experts.
COUNTIF and SUMIF - Microsoft Excel Tutorial
From the course: Excel for Accounting
COUNTIF and SUMIF
- COUNTIF and SUMIF are two of the most useful tools in Excel, which an accountant should expect to use all the time. These summarize information and calculate totals, even when that information isn't well organized to begin with. COUNTIF looks at a range of cells and counts how many of them equal a certain value. that can be a static value, such as a number or a text string in quotes, but usually it's a cell reference, and it counts how many cells in the range are equal to the contents of the reference cell. The syntax of a COUNTIF Formula is equals, COUNTIF, open parenthesis, the range of cells you're looking at, comma, then the value you're looking for, close parenthesis. Let's look at an example, using this list of 10,000 sales. You can find this data in the exercise file. Let's say you want to know how many sales Alice made. Type equals, COUNTIF, parenthesis, go to the sales details and select the column with the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.