Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |