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 |
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 |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com