I have a list of information that looks like the following (just 1000x larger):
Date (A)...|...Data (B)
9/1/07......|...10
6/1/08......|...20
9/1/08......|...10
6/1/09......|...15
9/1/09......|...31
What I'm looking for is a formula that will only pull the information in the Data field if it occurred between the months of Feb & July. Is it possible to do this without factoring in the year? I don't want a sum of items between those months, just a way to pull it. Basically, it's for my students that take test twice a year, I just want the scores they had during the spring semester.
Also, is there a way that I could add on to the formula to pull only the latest data? So in this case the data in 6/1/09.
Any help would be greatly appreciated. Thanks!
Last edited by PowerSchoolDude; 12-18-2009 at 03:42 PM. Reason: adjust table
Possibly, you could use Advanced Filter with criteria to extract the matching records (or filter in place).
See this link for help on Advanced Filter.
Another option: Pivot Table - Grouped by month
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
You could also try =SUMPRODUCT((Month(A$1:A$1000)>=2)*(Month(A$1:A$1000)<=7)*(B$1:B$1000))
I don't understand what you mean by this, considering you said you wanted it to be regardless of years. If you do only want this year, you can add *(Year(A$1:A$1000)=Year(today())) before the last closing parenthesis.Also, is there a way that I could add on to the formula to pull only the latest data? So in this case the data in 6/1/09.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks