If Statement

[Carlee]

Hi there,
I posted a similar questions earlier today and got help, then tried to apply
the solution to this formula and got an error.

I use the following calculation in a sheet. Where there is no value to
calculate, i want to have "NA" appear in the field.

=SUMPRODUCT(--('Daily Reading Master
Log'!B$3:B$400>=DATEVALUE("02/01")),--('Daily Reading Master
Log'!B$3:B$400<=DATEVALUE("2/29")),'Daily Reading Master Log'!BM$3:BM$400)

 

[Jeff Boyce]

Carlee

"... calculation in a sheet..." Are you describing Excel?

This newsgroup is dedicated to Microsoft Access, the relational database.
Databases don't have "sheets".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Carlee]

My Bad...i selected the wrong discussion.