Using IF(COUNTBLANK) Formula but want to exclude cells filled with N/A

  • I am currently running formulas IF(COUNTBLANK) to self fill other cells corresponding to dates in another cell. However, what I want to determine is how to take the column of data that has some cells filled with N/A where other are filled with dates, but I don't want the cell that the formula is in to change to a Y until all the empty cells (those not N/A) have a date in it.

    This is my current formula:

    Code
    =IF(COUNTBLANK('Special Vips'!K2:K20)=19,"N","Y")



    In the referenced cells, 17 have N/A but two will be populated with dates, I don't want the "Y" to show up until both cells have dates.

  • Re: Using IF(COUNTBLANK) Formula but want to exclude cells filled with N/A


    Try flipping the problem......


    You want "Y" when the range has 2 dates? COUNT counts dates but not errors


    =IF(COUNT('Special Vips'!K2:K20)=2,"Y","N")

  • Re: Using IF(COUNTBLANK) Formula but want to exclude cells filled with N/A


    Quote

    =IF(COUNT('Special Vips'!K2:K20)=2,"Y","N")



    This wasn't successful because the dates do not appear in sequential order. What I have in the column it's counting is the following:

    N/A
    N/A
    (blank) <---- a date would go here
    N/A
    N/A
    N/A
    (blank) <-----a date would go here

    What I was hoping to find is a formula that would ignore the N/A and only look for dates, responding with a "Y" when they are both filled in, otherwise return with a "N"

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!