Look Formula

[IRMA MENDOSA]

want to check the year also please


Thank's Ron
----- Original Message -----
From: Ron de Bruin
Newsgroups: microsoft.public.excel.programming
Sent: Saturday, March 13, 2004 10:54 AM
Subject: Re: Look Formula


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))

--
Regards
Frank Kabel
Frankfurt, Germany

want to check the year also please


Thank's Ron
----- Original Message -----
From: Ron de Bruin
Newsgroups: microsoft.public.excel.programming
Sent: Saturday, March 13, 2004 10:54 AM
Subject: Re: Look Formula


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

 

[Ron de Bruin]

Hi Frank

I got a private mail also Frank from the OP

I think the OP did not see your reply
I have mail the nswer private to the OP

 

[Frank Kabel]

Thanks Ron
Frank

 

[IRMA MENDOSA]

Thanks Guys You are great
it works just the way I need it