If Statement
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
--
Carlee
|