On Sun, 15 Mar 2009 08:00:49 -0000, "Peter" 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)




Do you use Excel 2003?
I think you will need Excel 2007 in order to use "whole column
reference".

Also, have a look under "Whole Column and Row References" at this page
http://msdn.microsoft.com/en-us/library/aa730921.aspx

Hope this helps / Lars-Åke