formula to count occurrences using multiple columns

Joined
Mar 25, 2015
Messages
2
Reaction score
0
I need a formula that will count the number of times a "Company" is "1, 2 or 3" based on the two columns

Column 1 Column 2
1 Company 1
2 Company 2
3 Company 3
NR Company 4
NR Company 5
1 Company 5
2 Company 3
3 Company 1
NR Company 4
NR Company 2
 
Joined
Nov 10, 2015
Messages
1
Reaction score
0
The COUNTIFS() function is great. See example below

=COUNTIFS($C$3:$C$10,F2,$B$3:$B$10,">0")
 

Attachments

  • CountIFs.zip
    11 KB · Views: 188

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top