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.
Bookmarks