Google Spreadsheets....need a simple formula

Discussion in 'Software' started by oh_no_not_her_again, Jan 4, 2013.

  1. oh_no_not_her_again

    oh_no_not_her_again Private First Class

    I have a Google spreadsheet with 2 separate columns of over 200 lines long each.

    I have spend 2 days looking for a formula that will count the empty cells (the full cells have no numeric values in them, just a X) I have tried every combination possible......COUNTBLANK, COUNT, ISBLANK, ISNUMBER......

    Can someone be so kind as to tell me the exact wording I need to write in the formula bar.......

    I know it should be really simple but it's not to me......

    :confused

    Thank you

    Onnha
     
  2. plodr

    plodr Major Geek Super Extraordinaire

  3. oh_no_not_her_again

    oh_no_not_her_again Private First Class

    Do you mean =ISBLANK(B2:B213)

    INFO in the filter box?

    Yikes, I hate being thick....
     
  4. plodr

    plodr Major Geek Super Extraordinaire

    I have no idea because I do not use google docs and very rarely use spreadsheets.
     
  5. usafveteran

    usafveteran MajorGeek


MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds