LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SLB
 
Posts: n/a
Default Counting data by certain years

Hello,

Here is my issue. I have a bunch of dates in one column that may have
different years. In another column I have the data that I need to count.
What I want to do is count the data by year. Here's my example to clarify:

Column A Column B
2/10/2003 8
3/1/2004 5
1/4/2004 4
5/4/2002 10

I want to count how many answers there in Column B that were entered in the
year 2003 (from Column A). In this case, there's 1. Then I want to count
how many answers there are in Column B that were entered in the year 2004
(from Column A). In this case, there's 2. Etc.
Please let me know if you can help me out with this!
Thanks!!!
 
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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Counting Rainfall Data TightIsobars Excel Discussion (Misc queries) 2 January 17th 05 11:45 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 01:16 AM.

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

About Us

"It's about Microsoft Excel"