Troubleshoot

[rwtrader]

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

 

[Jackpot]

Try
=AVERAGEIF(Range, ">" & NOW()-INT(NOW()) , Sum Range)

 

[Paul Telford]

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/tutorial...f-49faac8854c8/wpf-binding-beyond-the-li.aspx