excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2003

Excel 2003

resolvedResolved · Low Priority · Version 2003

S. has attended:
Excel Intermediate course

Excel 2003

How would you write your own countif function?

RE: Excel 2003

Hello

Thank you for your question and welcome to the forum.

To use COUNTIF, you need to first enter =countif(

Then select the range of cells within which you want Excel to count

Then type in a comma ,

Then enter what it is that you want Excel to count, e.g. if you wanted Excel to count how many times you had entered 0 in the range you selected, then type in 0

If you are asking Excel to look for a piece of text, e.g. the word overdue, then you need to enter the text inside double quotation marks, e.g. "overdue"

I hope this helps.
Amanda

Mon 16 Feb 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Server loaded in 0.09 secs.