Countif to return partial result?

1. Countif to return partial result?

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.

2. Re: Countif to return partial result?

HTML Code:
``=COUNTIF(C4:C19,J3)+COUNTIF(D4:D19,J4)+COUNTIF(E4:E19,J5)``

3. Re: Countif to return partial result?

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

4. Re: Countif to return partial result?

Thanks modytrane

5. Re: Countif to return partial result?

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

HTML Code:
``=IF(J5<>0,COUNTIFS(C4:C20,J3,D4:D20,J4,E4:E20,J5),COUNTIFS(C4:C20,J3,D4:D20,J4))``
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:

HTML Code:
``=IF(J5="",COUNTIFS(C4:C20,J3,D4:D20,J4),IF(J4="",COUNTIFS(C4:C20,J3,E4:E20,J5),IF(J3="",COUNTIFS(D4:D20,J4,E4:E20,J5),COUNTIFS(C4:C20,J3,D4:D20,J4,E4:E20,J5))))``

6. Re: Countif to return partial result?

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1