I am using 3 INDIRECT functions to find and gather rows of adjacent values from different worksheets inside STDEV.P. I would like to repeat this formula for several consecutive columns. The problem is that when 1 worksheet result returns N/A the whole formula returns N/A. If I use IFNA in front of each INDIRECT function, the formula results are still N/A. Any other suggestions?
Solved by A. L. in 11 mins