Thanks Guys, it worked
D Dave Peterson Nov 17, 2004 #2 Just a word of warning with Max's formula: =SUMPRODUCT(--(MONTH(A1:A100)=1)) If there are empty cells in A1:A100, then they get counted in January, too.
Just a word of warning with Max's formula: =SUMPRODUCT(--(MONTH(A1:A100)=1)) If there are empty cells in A1:A100, then they get counted in January, too.
M Max Nov 18, 2004 #3 Correct. Thanks, Dave ! (albeit an assumption was stated as a [hazy] caveat <g>) Use Frank's formula ..
Correct. Thanks, Dave ! (albeit an assumption was stated as a [hazy] caveat <g>) Use Frank's formula ..
