Excel formula help please :)

The Northern Monkey
The Northern Monkey Posts: 19,136
edited January 2011 in The Crudcatcher
Can anyone help me with a formula that does this...

Countblanks in column B IF column A contains a number or specific bit of text.

I just can't get countblank and IF to work together in 1 formula.

I would use a macro, but i'm creating this spreadsheet for a retard and i've been told to use no macros and to lock the formulas.

thanks in advance!
Santa Cruz Butcher

Comments

  • Proutster
    Proutster Posts: 785
    Will this link on nested IF statements help? I think it might point you in the right direction, I've used this example for something similar before and it helped me:

    http://www.experiglot.com/2006/12/11/ho ... nd-or-not/

    Good luck!!
    Giant Reign
    Mondraker Summum
  • Thewaylander
    Thewaylander Posts: 8,593
    bout to say use an if statment and if not 0/blank output a 1 so this can then be counted or added.
  • dd1
    dd1 Posts: 73
    you might of sorted this already, but you could try this.

    In column c use the formula =IF(AND(B1="",A1<>""),1,2)

    Copy this for the number of rows.

    at the bottom of column b use the formula COUNTIF(C1:C8,1) where C1:C8 is your range.

    then protect and hide column c

    seems to work
    Cannondale Super Six Hi Mod Sram Red

Categories