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