If Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlee - 28 Jan 2008 23:38 GMT

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)

Signature

Carlee

Reply to this Message

Red - 31 Jan 2008 23:47 GMT

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")

> Hi there,
> > I posted a similar questions earlier today and got help, then tried to
[quoted text clipped - 7 lines]
> > 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)

Reply to this Message