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

excel

ResolvedVersion 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.

Excel tip:

Quick Zooming in Excel with rollerball mouses

To zoom in and out of your page hold down the control key and roll the wheel up and down. This will zoom up and down 15% at a time.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.