Need Formula To Find Blank and NonBlank Cells

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with formula to calculate what column to use 1
How to Calculate something 2
grouping and subtotal by month 1
Determine current worksheet 6
Copy from one list to another in different time scales. Confusing? 2
Formula help required please 10
calculating inflows in each month depending on different paymentterms 1
Need help with SQL Statement in MS Access 2003 Chart 11

Top