Forum Discussion
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 is in column I.
At the end of document I would like it to say
Cogent 3
C&C 2
Any help will be really really grateful.
Kate
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 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.