If Statement

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)
Click to expand...
 
R

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Statement 2
Desparate..please help 4
Where no value, display "NA" - if statement? 3
If statement trouble 3
Using SumProduct in Code 2
Named Ranges in Functions 2
function tweak? 5
Date Issue 1

Top