Hi all,
I'm trying to compare an average of three cells to 0 and if that average is greater than 0 i want to sum another column. So I can do this for one cell rather than an average of three cells with this formula:
=SUMIF(N9:N110,">0",$I9:$I110)
So for the rows 9 to 110 if N is positive I include the corresponding value in column I. That's straightforward enough. The trouble I'm having is when I try to switch the N9:N110 to average(L9:N110) in order to check the average of L9,M9 and N9 and compare that to 0.
Any help would be appreciated.
Bookmarks