Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Data in Columns
Try this:
=SUMPRODUCT((A1:A15DATEVALUE("3/15/2007"))*(B1:B15="A")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "MDI Anne" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Data in Columns
WOOHOO!!!
That's it! Thank you so much!!! "RagDyeR" wrote: Try this: =SUMPRODUCT((A1:A15DATEVALUE("3/15/2007"))*(B1:B15="A")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "MDI Anne" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Data in Columns
You're welcome, and thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MDI Anne" wrote in message ... WOOHOO!!! That's it! Thank you so much!!! "RagDyeR" wrote: Try this: =SUMPRODUCT((A1:A15DATEVALUE("3/15/2007"))*(B1:B15="A")) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "MDI Anne" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |