| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 !!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 !!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 !!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count based on multiple date criteria | Excel Worksheet Functions | |||
| I need to count while using multiple criteria | Excel Worksheet Functions | |||
| Counting multiple cells using a criteria | Excel Discussion (Misc queries) | |||
| calculate percent from multiple criteria | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
