Forum Discussion
Solved
HELP! I am in a pickle
Hi I am stuck on a formula and new to Excel...... I need to count how many people from each category are attending a meeting (1 for yes and 0 for no). The response is in column H and category i...
katehutchins You can also use Pivot table to show the summary of all the categories and responses, i.e. attending and not attending.
Converting the source data into a table is recommended (not mandatory) for Pivot to auto adjust.
katehutchins If you are still looking for formula, you can use COUNTIFS as below, but PivotTable would be Dynamic, Error free, User Friendly, and compatible with all versions of excel.
If L2 has the category you wish to check for...
=COUNTIFS($I$2:$I$4,$L2,$H$2:$H$4,"0")
Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.