Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to compare one column to another column and if the two conditions
I am looking at are true, I would like it to be counted. Eventually adding all occurances of those two conditions. EX A B C D F G 1 5/14/2006 Indiana/01 John Doe enroll mail enter 2 5/14/2006 Indiana/02 John Doe enroll mail enter 3 5/14/2006 Indiana/01 Jane Plur enroll mail enter 4 5/14/2006 Indiana/03 John Paul enroll mail enter 5 5/14/2006 Indiana/01 Joe Dirt salary fax I want the result to capture the "B" column if it says "Indiana/01" and then the "D" column if it says "enroll" and add all of the occuances of both of those and spit out a value. I would greatly appreciate any help I can get on the matter. thanks Danny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Logic statement returns wrong answer. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |