"oldchippy" wrote in message
...
Peter;270369 Wrote:
Hi
Thanks for looking
Below is the formula i'm using and it works just fine.
=SUMPRODUCT(--(YEAR(Serial!$G$2:$G$3222)=$B$1),--(MONTH(Serial!$G$2:$G$3222)=D2)
What i'm trying to do is select the whole column (G) as below
=SUMPRODUCT(--(YEAR(Serial!G:G)=$B$1),--(MONTH(Serial!G:G)=D2)
I just can't get this to work, any ideas
Cheers
Peter (UK)
Hi,
Unless you have 2007 you can't specify the whole column with
SUMPRODUCT, but you can use G1:G65536
--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile:
http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=75374
Cheers Guys for your replies
I don't fancy upgrading to 2007 just yet, i'll use the G1:G65536 work around
Tanks again
Peter (UK)