Windows 8 and 8.1 Forums

count if excel

  1. #1

    Posts : 32
    Winodws 8 Pro With Media Center

    count if excel

    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 System SpecsSystem Spec

  2. #2

    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 System SpecsSystem Spec

count if excel

Similar Threads
Thread Forum
reallocated sector count warning
hi all sorry if this is the wrong place I have a reallocated sector count warning current 253 worst 252 threshold 63 data 7 status warning im not sure what it means to me so any help would be good please is the the computers way of telling me to replace the hard drive now thanks
Drivers & Hardware
How bad is the pc market ? Analysts count the ways
Windows 8 News
High DPC count for acpi.sys
This only occurs when I play a game that utilizes my Geforce GT540M on my laptop The "interrupts" on process monitor stays relatively low (below 1%) for the first 10-15 minutes of gaming but after that it shoots up to 22%+. I then used LatencyMon to check what is causing this and it shows that...
Performance & Maintenance, let me count the ways I hate you
For years, if you are logged onto, Microsoft has been redirecting google search results for, Technet, MSDN, etc through 1. Sometimes it doesn't work, and it's stalls on 2. When it does work, it tends to kill the browser back button, which gets...
General Support
Does the store have an app count limitation
Does the store have an app count limitation? I am curious, Does anyone have an app listing page that exceeds 10 rows vertically by 10 - or 100 per section? Or does anyone have a section that exceeds 10 rows vertically by 25 - or 250 per section? How many store apps do you have? 9453 9454...
Software and Apps
Unread email message count
Hello all Anybody know how I can get rid of the unread email message count on the wakeup screen after a lock screen? I don't have unread messages in my account or mail application but for some reason it shows a count of unread emails. Thanks
Browsers & Mail

Eight Forums Android App Eight Forums IOS App Follow us on Facebook