Please note that if you have more(!) than one segment using SUMPRODUCT - you
can omit all the "N"s.
SUMPRODUCT cannot calculate on TRUEs and FALSEs
However, if two, or more segments, of T & F are multiplied - the result is
always 0 or 1 which is very welcome by the function.
So: =SUMPRODUCT((MONTH($A$1:$A$40)=12)*(YEAR($A$1:$A$4 0)=2010)) will do
*** Please note the Multiplication instead your comma ***
Micky
--
והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"gooders" wrote:

I think I've got it using Mickey's formula:

=SUMPRODUCT(N(MONTH($A$1:$A$40)=12),N(YEAR($A$1:$A $40)=2010))

Thanks

"gooders" wrote:

Hi, this seems to be a very simple query but obviously too hard for my brain.
I have a column full of dates i.e.22/11/2009, 1/12/2009 etc. I may have
duplicates which isn't a problem. What I want to do is count the number of
rows that say were done in the month of November etc. I use Excel 2003.

Many thanks for any assistance.