ExcelBanter - COUNT IF - MULTIPLE CRITERIA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNT IF - MULTIPLE CRITERIA (https://www.excelbanter.com/excel-worksheet-functions/63992-count-if-multiple-criteria.html)

Matthew

COUNT IF - MULTIPLE CRITERIA

I wish to know the best way of getting a result for the following :-

I have a column of names on sheet A Column A.
I want to count the number of times the name occurs on Sheet B Column
A...BUT also need the following extra condition...Only count if Sheet B
Column B 0.

Thanks for your help in advance !!!

Bob Phillips

COUNT IF - MULTIPLE CRITERIA

=SUMPRODUCT(--(Sheet2!$A$1:$A$1000=A1),--(Sheet2!$B$1:$B$10000))

and copy down on Sheet1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Matthew" wrote in message
...
I wish to know the best way of getting a result for the following :-

I have a column of names on sheet A Column A.
I want to count the number of times the name occurs on Sheet B Column
A...BUT also need the following extra condition...Only count if Sheet B
Column B 0.

Thanks for your help in advance !!!

Matthew

COUNT IF - MULTIPLE CRITERIA

Thanks Bob!

"Bob Phillips" wrote:

=SUMPRODUCT(--(Sheet2!$A$1:$A$1000=A1),--(Sheet2!$B$1:$B$10000))

and copy down on Sheet1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Matthew" wrote in message
...
I wish to know the best way of getting a result for the following :-

I have a column of names on sheet A Column A.
I want to count the number of times the name occurs on Sheet B Column
A...BUT also need the following extra condition...Only count if Sheet B
Column B 0.

Thanks for your help in advance !!!

All times are GMT +1. The time now is 07:01 PM.