If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Troubleshoot
Can someone help me with the following statement:
=AVERAGEIFS(BeezidTable[final],BeezidTable[time],"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()) )") It returns DIV/0, but it should return a proper average. Thanks, Roy |
#2
|
|||
|
|||
Troubleshoot
Try
=AVERAGEIF(Range, "" & NOW()-INT(NOW()) , Sum Range) "rwtrader" wrote: Can someone help me with the following statement: =AVERAGEIFS(BeezidTable[final],BeezidTable[time],"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()) )") It returns DIV/0, but it should return a proper average. Thanks, Roy |
#3
|
|||
|
|||
more details please
Hi Roy, what data is in Beezidtable[final] and beezidtable[time]? Is your PC's clock correct?
rwtrader wrote: Troubleshoot 04-Jun-10 Can someone help me with the following statement: =AVERAGEIFS(BeezidTable[final],BeezidTable[time],"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()) )") It returns DIV/0, but it should return a proper average. Thanks, Roy Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Binding Beyond the Limitation of Name Scopes http://www.eggheadcafe.com/tutorials...nd-the-li.aspx |
Thread Tools | |
Display Modes | |
|
|