## Microsoft Excel 2003 Functions and Formulas

### Count Number of Actual Arguments in a Series

Summary: Display how many cells inside a series in an Excel spreadsheet actually hold data.

There may be instances in a Microsoft Excel 2003 spreadsheet where you allow a variable number of cells to have values, yet you need to determine how many values were actually entered.

For example, assume a Microsoft Excel 2003 spreadsheet where the user can enter values in column A from rows 1 to 10. However, not all rows must contain values:

A1: 23
A2: 11
A3: 45

Even though cells A4 through A10 are blank, formulas should be designed to handle this open-ended series of values.

Enter the =COUNT function. This displays the number of actual values that were entered into a series of cells.

Syntax:

=count(SERIES)

* SERIES is any series of cells in an Excel spreadsheet.

Add: Del.icio.us | Digg | Furl | My Yahoo!
{"ft_lang_label":"__label__en","ft_lang_prob":0.83686745,"math_prob":0.49862945,"size":1089,"snap":"2022-27-2022-33","text_gpt3_token_len":270,"char_repetition_ratio":0.1281106,"word_repetition_ratio":0.021857923,"special_character_ratio":0.25528008,"punctuation_ratio":0.15486726,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.97083956,"pos_list":[0,1,2,3,4,5,6,7,8],"im_url_duplicate_count":[null,null,null,null,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-07-06T18:27:58Z\",\"WARC-Record-ID\":\"<urn:uuid:01fe01d2-43ae-4d9f-a342-4c9ed27954f3>\",\"Content-Length\":\"7555\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:5517a2b3-9fdf-40be-9926-ab38b1efd956>\",\"WARC-Concurrent-To\":\"<urn:uuid:26c7fd75-036c-47d5-9d87-e648f83ec11a>\",\"WARC-IP-Address\":\"104.21.35.3\",\"WARC-Target-URI\":\"https://tipsforspreadsheets.com/microsoft_excel_2003_function_0020.html\",\"WARC-Payload-Digest\":\"sha1:QGVYCUD6OWATHSCPHX26WT62K5DOFQRA\",\"WARC-Block-Digest\":\"sha1:VEM6DOUGSEL7LM6Z4PCVSWXT262HYYDD\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-27/CC-MAIN-2022-27_segments_1656104676086.90_warc_CC-MAIN-20220706182237-20220706212237-00325.warc.gz\"}"}