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

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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.
 

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

Similar Threads

Excel Count of Consecutive Data 0
Count the columns from one sheet and paste it in another sheet 0
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Excel Excel Vlookup formula based on cell data 7
Excel A CountIF question... I think 2
Excel How to count from a column if specific condition in another column is true 3
Last Modified By in a cell by user 3
Excel Excel: Sort a column with #.#.# number and keep other column 0

Top