microsoft.excel.training

microsoft.excel.training - Countif

Resolved · Low Priority · Version Standard

Countif

Hayley has attended:
No courses

by - delegate Hayley [1 post] (2007 Sep 21 Fri, 15:06) Reply

how to use it?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: countif

by - trainer Richard platinum contributer [818 posts] (2007 Sep 21 Fri, 15:16) Reply

CountIf works on the basis that if any value in the range you select meets your criteria, then it will be added to the count.

COUNTIF(range,criteria)

Range:
is the range of cells from which you want to count cells.

Criteria:
is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.

· Tips to Facilitate Printing of Excel worksheets
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Four
· Training Budgets In A Bad Economy
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Rate this page: