Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 13:46:51 +0000



Post From: Help with Referencing A Range of Data

[2020-01-21 03:41:09]
sourdubber - Posts: 52
Please disregard. Found the fix.

=AND(SUM(P3:P5)>0,E3<B3)

In the document the examples was given in this format, which was a bit confusing:
AVERAGE(ID0.SG1[0:-10])
=AVERAGE(O[0:-10]) > 100