| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if in multiple rows / columns
518 rows, columns a-ia
Need to count if five rows says houston then in column b how many times does it say XXXX and in same column how many times does it say XXXX, etc. etc for each column but only for those houston rows, cant use subtotal/auto count as each column has multiple variables |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if in multiple rows / columns
Your problem is not clear. Pl. provide more information with sample data.
"chanse44" wrote: 518 rows, columns a-ia Need to count if five rows says houston then in column b how many times does it say XXXX and in same column how many times does it say XXXX, etc. etc for each column but only for those houston rows, cant use subtotal/auto count as each column has multiple variables |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Count entries in columns and rows | Excel Worksheet Functions | |||
| Conditional count of rows dependent on multiple columns | Excel Worksheet Functions | |||
| How to Count Rows with defined values in multiple columns | Excel Worksheet Functions | |||
Linear Mode
