LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Counting Data in Columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Data From 2 Different Columns dellbad Excel Discussion (Misc queries) 2 February 26th 07 07:01 PM
Counting in two columns PedersenJ Excel Worksheet Functions 3 August 8th 06 12:24 AM
Counting data columns with dates Manni Excel Discussion (Misc queries) 2 April 11th 06 02:05 PM
Counting data in columns telewats Excel Discussion (Misc queries) 1 February 21st 06 03:35 PM
counting columns jpcblood Excel Worksheet Functions 1 August 10th 05 12:41 AM


All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"