Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Counting Rainfall Data | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |