PMRetired2012
Board Regular
- Joined
- Aug 6, 2019
- Messages
- 123
Hello
The formula im trying to write is a formula like this one : =IF(ISNUMBER(AVERAGEIF(B22:AL22,">0")),AVERAGEIF(B22:AL22,">0"),"0") except where there is one range (B22:AL22) i want to use 3 ranges which are 3 diffrent rows( B4:AL4, B6:AL6,B8:AL8) All im really doing is adding 3 ranges after the average if and before the ">0" on both sides of formula.
Dennis
The formula im trying to write is a formula like this one : =IF(ISNUMBER(AVERAGEIF(B22:AL22,">0")),AVERAGEIF(B22:AL22,">0"),"0") except where there is one range (B22:AL22) i want to use 3 ranges which are 3 diffrent rows( B4:AL4, B6:AL6,B8:AL8) All im really doing is adding 3 ranges after the average if and before the ">0" on both sides of formula.
Dennis