Excel Count number of instances in a column

J

JP2

Joined
Oct 10, 2017
Messages
1
Reaction score
0
I need to calculate certain numbers. Below is an example of what i need.
The split in cells means 2 separate sheets. I need to pull how many b's from User 1 and put it into another sheet.
And be able to replicate this for the rest of the users.
upload_2017-10-9_20-34-3.webp
 
Welcome to PCR :).

You'll want to use the COUNTIFS tool to do this.

For example, on the second sheet in B2, you could have something like:

Code: 
=COUNTIFS(Sheet1!A:A,"1", Sheet1!D:D,"b")

Then, in B3 for the 2nd user, you'd replace the "1" in the formula with "2" and so on.
 
Back
Top