Counting the values for data in multiple columns

New Contributor

Hello - I am new here and hoping to find some assistance with a formula.  I need to count the number of elections based on the category, which will involve taking data from one column and adding the value in another to provide the result.  I have attached a sample.  Please let me know if you need additional info to assist - I think this is an easy one but have spent too much time trying...Thank you

2 Replies


You could create a pivot table, or use a COUNTIFS formula. See the attached version.

Thank you! This is great, I really appreciate it!