Sum by date

[djvj]

In A column, I have a range of dates as I add to them every week, from 2007 to 2008. F,G,H,I Columns all contain a "1" if on that day a specific task was performed. I have a summary page that adds up all these 1's to calculate how many of these tasks were done.

What I can't figure out is how to add just the 1's for 2007 or 2008 and sum them up. Sheet looks like this. Use google link for a better understanding.

A B C D E F G H I
1 DATE AREA OLD NEW NAME SPLIT1 SPLIT2 SPLIT3 SPLIT4
2 2/2/2007 1 1
3 5/12/2007 1 1
4 12/25/2007 1 1 1
5 1/5/2008 1 1
6 2/18/2008 1 1 1
7 3/9/2008
8 3/20/2008 1 1

I just copied from excel to google to make it easier to understand. http://spreadsheets.google.com/pub?k...HC4MW8BTtVPYDA
Note the 2007 and 2008 rows, I want to have the sum of the b split, 1, 2, 3 and return carriers of those years shown there.

Thank you for any help.

[Portuga]

Add an extra column called Year and use the =year(A1) formula, if it interestes you, add also the =month( or even the =weeknum( formulas and then apply a pivot table to the data.

or

A sumproduct formula will also help after the =year( column is in place

[djvj]

Thanks Portuga. I took your advice and found some additional ideas that do work, but requires the extra column with the =year function. This is the formula that works:

{=SUM((J5:J300=2007)*(Q5:Q300=1))}

I wish I could do without the =year column though. If anybody knows a better way please do tell.