Countif to return partial result?

[singerbatfink]

Hi Im a bit stuck

Im using countifs to return values based on 3 set criteria. The criteria are chosen using vlookups

Is it possible to return partial search results based only on 2 criteria?

Ive uploaded a mock up to demonstrate.

Ive selected Sat as Criteria 1, and Aug For Criteria 2, but nothing yet for criteria 3. As predicted the COUNT is zero because all 3 criteria have not been met..

Id like it to be able to return partial results, Is that possible

There for the COUNT would be 4 as Sat, and Aug appear 4 times.#

HELP much appreciated.

[modytrane]

How about:

[modytrane]

sorry, misunderstood the issue.
Let me think of something else.

[singerbatfink]

Thanks modytrane

[modytrane]

If Year is the only one that could be blank then you can use the following:

With the situation described in your post, this will give you result of 4.

If it is possible to be missing any one of those three [Day, Month or Year] then you may have to build in IF conditions for all three possibilities.
Something like:

[modytrane]

You also have to clean up few other things.
Your day column has Tue and Tues.
Your data validation list has Jan.Feb,Mar,Apr.........
You need to change . to , after Jan.