Right Bob it does work, Thanks
At first I wanted to select the whole column as a range as in this sample
=SUMPRODUCT(--(MONTH(Sheet2!A:A)=1),Sheet2!E:E), this did not work, I had to
fix cell position as shown in your sample above.
I wanted the select the cell column because the Data that I am refreshing
"from an external source" is set to change with every refresh. Looks I will
have to fix this in another way so the data stays put in the same cell of the
excel worksheet.

"Bob Phillips" wrote:

Not really, it does work I tested it.

#NAME usually means that it doesn't recognise one on the words, and there is
only SUMPRODUCT and MONTH in there that it might not. Check that there are
no spurious - that crept into the copy, there should only be two, just
before the (MONTH

--

HTH

RP
(remove nothere from the email address if mailing direct)


"FBS" wrote in message
...
Thank you Bob for the quick responce, the formula gives me an error
#NAME?
what is the cause? any thoughts?

"Bob Phillips" wrote:

=SUMPRODUCT(--(MONTH(Sheet1!A1:A100)=1),Sheet1!B1:B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"FBS" wrote in message
...
I have two columns in excel that gets its data from an access
database.
The
two columns are Calendar dates and the other numbers, I would like to
have
a
formula in a second worksheet that looks up a range of dates i.e.;
March
Sales and displays a sum of the corresponding figures in the second
column.--
do it right, do it once