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
Related Threads
reallocated sector count warning in Drivers & Hardware
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
High DPC count for acpi.sys in Performance & Maintenance
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...
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...
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...
Unread email message count in Browsers & Mail
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
Eight Forums Android App Eight Forums IOS App Follow us on Facebook