J
JT
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
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