count if excel

philip95

Member
Member
Messages
32
in excel if type "=conuntif(a1:c10,"a")
it will count all the cell with a in
but is there where so if the cell had aa it would count that cell as 2
 

My Computer

System One

  • OS
    Winodws 8 Pro With Media Center
    Computer type
    PC/Desktop
    System Manufacturer/Model
    Made myself
    CPU
    Quad Core 4.2 GHz
    Motherboard
    ASUS
    Memory
    8GB
    Hard Drives
    2TB (system drieve)
    2TB (Backup drive)
    Cooling
    Lots of fans
It should not be hard for you to try & see.
Just take a count now, add the word alpha to a cell. If it is just counting the number of cells wit 'a', it should only count once. If it is counting number of times 'a' is used, then it will count twice.
That's just my take as a professional rookie. I only have MS Works and it has popup saying not a correct formula for MS Works spreadsheet.
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w
Back
Top