Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 28
  • The Facebook Platform

Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default MS Excel 2007 Lecture # 28

    "Excel 2007 Count Function - Excel Count Function Example"


    The syntax for the Count function:
    =COUNT (value1[,value2,...]) whereby
    value1, value2,... is one or more ranges, arrays, function results, expressions, or literal values of which you want the count.

    To demonstrates the use of the Count function

    • Create a spreadsheet as follow:

    Name:  excel-2007-count-function-worksheet.jpg
Views: 303
Size:  26.2 KB

    • Click on the cell C9.
    • From the Formula tab, in the Function Library group, click the More Functions icon and point to Statistical from the drop down menu, click the COUNT command

    MS Excel 2007 Lecture # 28-excel-2007-count-function-arguments.jpg







    • From the Function Arguments dialog box displayed, enter C4:C8 in the Value1 entry. The Count function will calculate the number of occurrences in the range from C4 to C8.
    • Click OK.
    • Repeat the above process for the cells D9 and D10 to get the results.

    Name:  excel-2007-count-function-result.jpg
Views: 372
Size:  27.4 KB
    Find Me On Social Networks

    Facebook | Twitter | Google+


  2. #2
    Join Date
    Jul 2011
    Location
    Rawalpindi
    Posts
    1
    Points
    1.00
    Rep Power
    0

    Default

    Asalam o alikum,
    Plz mujhay yah btain kah work book main selected cell ko protect kasay kya jata hay,

    thnx

  3. #3
    Join Date
    Jun 2011
    Location
    اللہ کی زمین
    Age
    28
    Posts
    383
    Points
    521.88
    Rep Power
    920

    Default

    Waalikumaslam!!

    You just want to Protect Selected Cell?
    Signature - MS Excel 2007 Lecture # 28
    idf69z - MS Excel 2007 Lecture # 28


 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •