| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Occurance of data in multiple columns
I have three columns of data. I want to count how many
times all three have specific values. For example,column A is Day, column A is month, column B is day and column C is year. How many times will a specific month, day and year be found. |
|
#2
|
|||
|
|||
|
Hi Jerry
one method assuming your format is .........A.................B..................C 1....Month..........Day...............Year 2...Jan.................5...................2005 3...Jan................3....................2005 =SUMPRODUCT(--(A2:A9&B2:B9&C2:C9="Jan52005")) Cheers JulieD "Jerry" wrote in message ... I have three columns of data. I want to count how many times all three have specific values. For example,column A is Day, column A is month, column B is day and column C is year. How many times will a specific month, day and year be found. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
