SOLVED

HELP! I am in a pickle

Copper Contributor

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

 

katehutchins_0-1690980357431.png

 

Any help will be really really grateful.

 

Kate

 

 

2 Replies
best response confirmed by katehutchins (Copper Contributor)
Solution

@katehutchins You can also use Pivot table to show the summary of all the categories and responses, i.e. attending and not attending.

 

nimesht_0-1690981503394.png

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")

 

nimesht_0-1691762289177.png

 

Use Like if this post helped to solve your issue and Mark as Best Response if the request can be closed.

1 best response

Accepted Solutions
best response confirmed by katehutchins (Copper Contributor)
Solution

@katehutchins You can also use Pivot table to show the summary of all the categories and responses, i.e. attending and not attending.

 

nimesht_0-1690981503394.png

Converting the source data into a table is recommended (not mandatory) for Pivot to auto adjust.

View solution in original post