Hello!

I am trying to design an output for my spreadsheet which shows the
number of items in a list that match user selected criteria. For
example with the following data set:

A B
1 Male? Over 18?
2 TRUE TRUE
3 TRUE FALSE
4 FALSE TRUE
5 FALSE FALSE
6 FALSE TRUE

I would use the following function:

=COUNTIFS($A$2:$A$6,[User input 1],$B$2:$B$6,[User input 2])

Where the user inputs are TRUE or FALSE drop down boxes that allow the
user to select the gender and age categories they wish to count.

I wish to amend this formula so that I can have a "Don't Care" option
in my user inputs. This would allow the user to count the number of
items that match only one of the criteria.

The real life version of this has a large number of columns all
containing booleans.

I do not want to use a pivot table for this.

Does anybody know how I could achieve this?

Thanks

John