Need Formula To Find Blank and NonBlank Cells

  • Thread starter Thread starter hilltop55
  • Start date Start date
H

hilltop55

I have a worksheet with 6 columns (by Month)

Sep Aug Jul Jun May Apr

I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>

So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
 
Back
Top