Look Formula

[IRMA MENDOSA]

I want to check the year also please


Thank's Ron













Try this

=SUMPRODUCT((MONTH(C2:C1000)=1)*1)

=SUMPRODUCT((MONTH(C2:C1000)=2)*1)

If you want to check the year also post back

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




look formula

Is there a way to add in J1 how many january i have in C2:C1000
to add in J2 how many February I have in Cell C2:C1000
Etc.
Thanks in advance













Try this

=SUMPRODUCT((MONTH(C2:C1000)=1)*1)

=SUMPRODUCT((MONTH(C2:C1000)=2)*1)

If you want to check the year also post back

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




look formula

Is there a way to add in J1 how many january i have in C2:C1000
to add in J2 how many February I have in Cell C2:C1000
Etc.
Thanks in advance

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((MONTH(C2:C1000)=1)*(YEAR(C1:C1000)=2004))
and
=SUMPRODUCT((MONTH(C2:C1000)=2)*(YEAR(C1:C1000)=2004))