Reply to thread

Message

<blockquote data-quote="URkidding" data-source="post: 1676447" data-attributes="member: 361098">Thanks Sawday - Here's what I came up with that works greatIF(SUM(P2<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />356)=0,0,AVERAGEIFS(P2<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />356,P2<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />356,&quot;&gt;31&quot;,P2<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />356,&quot;&lt;242&quot;)÷30)It calls a zero if all cells are zero and /30 to give me a monthly average</blockquote>

[QUOTE="URkidding, post: 1676447, member: 361098"] Thanks Sawday - Here's what I came up with that works great IF(SUM(P2:P356)=0,0,AVERAGEIFS(P2:P356,P2:P356,">31",P2:P356,"<242")÷30) It calls a zero if all cells are zero and /30 to give me a monthly average [/QUOTE]

Verification

Name this item 🌈