Year and Month Question?
 

Hi! Frank Kabel

Thanks for your help. One more question for you.

If I assign say "Aug" in column "B1". How do I quote in the formula s
that it understand that it is equal to 8.

e.g. like this (Month(Full!$A$1000:$A$2000)=B1)

Thanks
Michael

Frank Kabel Wrote:
Hi
try:
=SUMPRODUCT((Full!$K$1000:$K$2000=2)*(Full!$AD$100 0:$AD$2000=1)*(Month(
Full!$A$1000:$A$2000)=8)*(YEAR(Full!$A$1000:$A$200 0)=2002))

--
Regards
Frank Kabel
Frankfurt, Germany




--
Michael16
-----------------------------------------------------------------------
Michael168's Profile: http://www.excelforum.com/member.php...info&userid=60
View this thread: http://www.excelforum.com/showthread.php?threadid=27449

Year and Month Question?
 

You wouldn't. You would put 8 in B1. If you want to put in Aug, then put a
formula in B1 that will translate that to 8

in B1 (Aug in A1)

=IF(A1="","",MONTH(DATEVALUE(A1 & " 1, 2004")))



--
Regards,
Tom Ogilvy

"Michael168" wrote in message
...

Hi! Frank Kabel

Thanks for your help. One more question for you.

If I assign say "Aug" in column "B1". How do I quote in the formula so
that it understand that it is equal to 8.

e.g. like this (Month(Full!$A$1000:$A$2000)=B1)

Thanks
Michael

Frank Kabel Wrote:
Hi
try:
=SUMPRODUCT((Full!$K$1000:$K$2000=2)*(Full!$AD$100 0:$AD$2000=1)*(Month(
Full!$A$1000:$A$2000)=8)*(YEAR(Full!$A$1000:$A$200 0)=2002))

--
Regards
Frank Kabel
Frankfurt, Germany





--
Michael168
------------------------------------------------------------------------
Michael168's Profile:
http://www.excelforum.com/member.php...nfo&userid=605
View this thread: http://www.excelforum.com/showthread...hreadid=274495

Year and Month Question?
 

Hi
as Tom said. Don't do this. But as an alternative try:
(TEXT(Full!$A$1000:$A$2000,"MMM")=B1)


--
Regards
Frank Kabel
Frankfurt, Germany

"Michael168" schrieb im
Newsbeitrag ...

Hi! Frank Kabel

Thanks for your help. One more question for you.

If I assign say "Aug" in column "B1". How do I quote in the formula
so
that it understand that it is equal to 8.

e.g. like this (Month(Full!$A$1000:$A$2000)=B1)

Thanks
Michael

Frank Kabel Wrote:
Hi
try:

=SUMPRODUCT((Full!$K$1000:$K$2000=2)*(Full!$AD$100 0:$AD$2000=1)*(Month(
Full!$A$1000:$A$2000)=8)*(YEAR(Full!$A$1000:$A$200 0)=2002))

--
Regards
Frank Kabel
Frankfurt, Germany





--
Michael168
---------------------------------------------------------------------
---
Michael168's Profile:
http://www.excelforum.com/member.php...nfo&userid=605
View this thread:
http://www.excelforum.com/showthread...hreadid=274495