# Counting Data in Columns

G

#### Guest

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

R

#### RagDyeR

Try this:

=SUMPRODUCT((A1:A15>DATEVALUE("3/15/2007"))*(B1:B15="A"))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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

G

#### Guest

WOOHOO!!!

That's it!

Thank you so much!!!

R

#### Ragdyer

You're welcome, and thanks for the feed-back.