microsoft excel training

microsoft excel training - Excel intro

Resolved · Low Priority · Version Standard

Excel intro

Debbie has attended:
Excel Introduction course

by - delegate Debbie [1 post] (2008 Jan 24 Thu, 09:20) Reply

What is the difference between count - countA?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	2	book now	£495	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel intro

by - trainer Pete platinum contributer [803 posts] (2008 Jan 31 Thu, 13:32) Reply

Hi Debbie, Thank you for the post, To answer your question, the difference between COUNT and COUNTA;
COUNT will consider the selected range of cells and return a number which is the number of values in the range. ie just numbers.
COUNTA will consider the selected range of cells and return a number which is the number of values and lables in the range, ie everything. So if the range has headings or labels, COUNT will ignore them, but COUNTA will include them. I hope that helps, best regards Pete.

· Microsoft Excel Courses Teach Advanced Macro Techniques
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Identifying Suitable Candidates For VBA For Excel Training

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

Rate this page: