| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional COUNTIF Function
"Blair" wrote in message
... Hi, I have two columns with different values in and I would like to count the number of times certain values appear in the same row. i.e. Column A contains random numbers from 1-10 Column B contains random letters between A-Z How could I count the number of times the number "1" is in the same row as letter "A"?? Struggling at the moment with this so any help would be appreciated. The shortest formula: =SUMPRODUCT((A1:A10=5)*(B1:B10="B")) Bruno |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
| Conditional Function Application | Excel Discussion (Misc queries) | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Countif Function -Nested | Excel Discussion (Misc queries) | |||
| How do I use COUNTIF in a SUBTOTAL function to differentiate the . | Excel Worksheet Functions | |||
Threaded Mode
