If Statement

  • Thread starter Thread starter Carlee
  • Start date Start date
C

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)
 
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
 
Back
Top