Countif formula

halcyoneus

Board Regular
Joined
Mar 26, 2003
Messages
147
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening halcyoneus

Try using the SumProduct function :

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

HTH

DominicB
 

halcyoneus

Board Regular
Joined
Mar 26, 2003
Messages
147
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
 

Forum statistics

Threads
1,136,350
Messages
5,675,246
Members
419,557
Latest member
razlevav

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top