Forum Discussion
Using a cell ref. with AVERAGEIF & INDIRECT in this example.
Please help to fix my Excel expression. The following works and returns the average value in the range, as long as values are <0.35. =AVERAGEIF(INDIRECT(($AE$5&":"&$AG$5)),"<0.35") When I replace ...
Hi,
Use this syntax in the criteria argument:
"<"&Calc!R2
Regards
Thank you for your speedy response Haytham. That fix worked like a charm! I appreciate it...