Hi all,
First of all, I don't know if attaching a mock sheet will help. I am officially working with Office 365 (web based), but I have Office 2016 on the desktop so some of the formulas won't work. Anyway...
Here is the formula I am working with which is located in cell N3 "=AVERAGEIFS(Raw!I:I,Raw!A:A,B3,Raw!D:D,F4)+XLOOKUP(B3&F3,Raw!A:A&Raw!D:D,Raw!J:J, 0)" the problem is for many cells the return value will be "#DIV/0!".
Though the results are expected, I am wanting to replace that return value with zero. I tried using IF and IFERROR but somehow it's not working out.
Bookmarks