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)

 

[Red]

not sure if you still need help with this, but I've got something that can
work for you (even though it's not especially pretty).

If you surround your formula in an If statement, then it'll give you the
result you want. Try something like this:

=IF(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)>0,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),"N/A")