Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know this has probably been answered a gazillion times before, but I can't
seem to find it. I have 2 columns, one with a date, the other with text. I need to count the times "A" appears in column B when column A has a date 3/15/2007. I would like to think there is a formula I can put at the bottom of column B for both "A" and "F" for this condition. 3/2/2007 A 3/16/2007 A 3/20/2007 A 3/13/2007 A 4/5/2007 F 4/20/2007 A 3/17/2007 A 3/4/2007 F 3/22/2007 F 3/7/2007 A 4/18/2007 A 3/7/2007 F 3/19/2007 F 3/7/2007 F 4/3/2007 A Thanks, in advance, for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Data From 2 Different Columns | Excel Discussion (Misc queries) | |||
Counting in two columns | Excel Worksheet Functions | |||
Counting data columns with dates | Excel Discussion (Misc queries) | |||
Counting data in columns | Excel Discussion (Misc queries) | |||
counting columns | Excel Worksheet Functions |