Desparate..please help
 

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?

--
Carlee

Desparate..please help
 

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?

Desparate..please help
 

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?

Desparate..please help
 

In your formula that worked, just replace

DATEVALUE("01/01")


with


DATE(YEAR(TODAY()),1,1))

do the same for the last of January as well


you probably get the ref error because you copied John's formula and somehow
you got an extra space or something in the sheet name string. A ref error
basically tells you that the reference is non existent meaning you refer to
a sheet or a cell that doesn't exist


--


Regards,


Peo Sjoblom


"Carlee" wrote in message
...
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?

Desparate..please help
 

the #REF! error means your sheet names aren't correct...

In article ,
Carlee wrote:

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

Ideas for the desparate one?