May 24 2019 05:37 AM
The following formal has a #value! error. I havent found the reason:
=SUM((($AW30:$AY30)/3)*($AZ30))/($AZ30)
All cells in the formula are at zero when the stock market is closed. I have not yet tested the formula during market open because Im trying to finish before open. Also I want the spread sheet to work when market is closed, even though the data the formula looks at is zero. My spread sheet wont work if this formula returns this error.
May 24 2019 05:54 AM
FOLLOW Up:
I should mention that this formula came from these instructions:
May 24 2019 11:30 AM
@Greg Bonaparte , formula like
=SUM( (A1:C1)/3 )
returns #VALUE error. Use SUMPORODUCT instead
=SUMPRODUCT( ($AW30:$AY30/3)*$AZ30)/$AZ30