Countif formula

[halcyoneus]

Not sure if Countif is the corent formula to be using....

I have 2 columns in a spreadsheet. Column A will have a multiple names in them, we'll use Bob and Joe for example. Column B will have a number 0-3 in it. I was trying to use the Countif formula to figure out how many entries there are for Bob with a 0 in column B, Bob with a 1 in column B, Joe with a 0 in column B......and so on.


Something like this.....

COLUMN A.....COLUMN B
Bob....................1
Bob....................0
Joe.....................3
Joe.....................2
Bob....................1

NAME..0's...1's...2's...3's
Bob.....1......2.....0.....0
Joe......0......0.....1.....1

~Hal

 

[DominicB]

Good evening halcyoneus

Try using the SumProduct function :

=SUMPRODUCT(--(Sheet1!$A$1:$A$100="Bob"),--(Sheet1!$B$1:$B$100= 0 ))

HTH

DominicB

 

[Brian from Maui]

You could also use a Pivot Table.

 

[halcyoneus]

Good evening halcyoneus

Try using the SumProduct function :

=SUMPRODUCT(--(Sheet1!$A$1:$A$100="Bob"),--(Sheet1!$B$1:$B$100= 0 ))

HTH

DominicB

Awesome ! ! !

Works exactly they way I wanted it to.

~Hal