Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
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") "Carlee" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statement help | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |