Prev: How to make a conditional Median function?
Next: Count number of instances
From: rwtrader on 4 Jun 2010 10:28
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
From: Jackpot on 4 Jun 2010 10:43
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
 | 
Pages: 1
Prev: How to make a conditional Median function?
Next: Count number of instances