Results 1 to 3 of 3

Countif Function

This is a discussion on Countif Function within the Excel Questions forums, part of the Question Forums category; I have a column of data which I would like to count the total # of cells which begin with ...

  1. Apr 28th, 2004, 01:56 PM #1
    jhudson
    jhudson is offline
    New Member
    Join Date
    Aug 2003
    Posts
    40

    Default Countif Function

    I have a column of data which I would like to count the total # of cells which begin with the letter E. All of the cells have 5 charaters which begin with E. ie) E5506, E7609, E3456, etc. All I need to do is come up with a final count for all of the cells in the column which start with "E"

    Please Help...

    Thank You
    Reply With Quote Reply With Quote
  2. Apr 28th, 2004, 02:00 PM #2
    Aladin Akyurek
    Aladin Akyurek is offline
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    56,071

    Default Re: Countif Function

    =COUNTIF(Range,"E*")
    Reply With Quote Reply With Quote
  3. Apr 28th, 2004, 02:06 PM #3
    jhudson
    jhudson is offline
    New Member
    Join Date
    Aug 2003
    Posts
    40

    Default Re: Countif Function

    Thanks!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules


DMCA.com