Hi there,
THanks for the quick response. Using what you have provided, i am now
getting a 'Ref!' error.

Ideas for the desparate one?


--
Carlee


"JE McGimpsey" wrote:

His date settings are probably in m/d/y format, so DATEVALUE("31/1")
throws a #VALUE! errror. Try:

=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$375=DATE(YEAR(TODAY()),1,1)), --('Daily Reading Master
Log'!B$3:B$375<=DATE(YEAR(TODAY()),1,31)), 'Daily Reading Master
Log'!BM$3:BM$375)


In article ,
Carlee wrote:

Hello all

I use the following function on my laptop and it works beautifully:

=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master
Log'!B$3:B$375<=DATEVALUE("31/01")),'Daily Reading Master Log'!BM$3:BM$375)

When i send the workbook to my the user, all he sees is VALUE! in the boxes
where this function is used.

Why?
How can i fix this?