Is there way to count if one or both columns haven't been filled?

Hello all,

This is my first cry for Excel help.

I am hoping to edit my current spreadsheet that is using

Please Login or Register  to view this content.

Currently this is only counting when both sections aren't filled (Outcome/Feeling). I would like it to work so even when one hasn't been filled, it is still adding to the count by 1

So if "M" has a row that has both Outcome and Feeling blank then it would add 1 to the evaluation count and if "M" has either Outcome or Feeling blank, it would also be marked and add 1 to the count.

Your assistance is so welcome as I am ever so stuck on this issue!

Many Thanks,
Excel Rookie

Hi
please attached your excel file.

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

I have now included a test sheet to exemplify what I mean. I hope this helps.

Thank you again.

Further on from my previous counter, I have attached a basic counter to this post.

I'm unsure if this would work with what I think is called '3D' criteria like date ranges shown in my original formula in the 1st post.

Any ideas how to take the basic counter I've attached and make it fit with the advanced criteria shown in the original post?

Try to combine this in your formula:
=IF(OR(D2="",E2=""),1)

Originally Posted by belinda200

Try to combine this in your formula:
=IF(OR(D2="",E2=""),1)

What do you mean by combine with the formula?

Dont realiy understand your test file
Is your result in J5? There is already a formula that works there.....

Originally Posted by belinda200

Dont realiy understand your test file
Is your result in J5? There is already a formula that works there.....

I am unsure if the test formula works with more advanced criteria as shown in my first post. In the actual counter there is more parameters set like "Date_Closed". I don't know how to then go and include these criteria in the basic sheet I have uploaded here.

Thanks for your help.

You didnt say what is your criteria. You just wrote you want to evaluate ABC . I f you give a specific example - maybe someone will be able to help you.

Shown in my starting message above. Test counter is barebones version of the one we use.

The starting one is not in excel, and is hard to understand. why dont you detail your conditions in the test file?
If you want help - you will have to be more clear , just concentrate everything in 1 file, instead of having to jump from one post to another to understand your request....