Trouble with Mean function

Hi, I wrote the following code, but it is returning NaN for the output of AvgRule1. It should be the mean of X, when A < 1. I have attached the spreadsheet and the code I used to this post. Please let me know if you can help. Also, there is no NAN data in the spreadsheet. Here's the code:

clear all 

sheet = 1; 

A = xlsread('example1.xlsx', sheet, 'C:C'); %Choose row
X = xlsread('example1.xlsx', sheet, 'B:B');%Choose row
Y = xlsread('example1.xlsx', sheet, 'A:A');%Choose row

   P2SRule1 = X(A<1); %select X values where rule is true 
   AvgRule1 = mean(P2SRule1); %mean of matrix 
   avgDaysHeldRule1= mean(Y(A<1)); %Avg days heald where data meets conditions

   A = { AvgRule1, avgDaysHeldRule1}; %create a variable with all data needed for spreadsheet  

   sheet = 2; %sheet for desired output
   xlRange = 'B2'; %desired range for output
   xlswrite('example1.xlsx', A, sheet, xlRange) %add data to spreedsheet

Answer 1

[Star Strider]

If you have a recent version of MATLAB, you can use mean with the 'omitnan' flag:

M = mean(A,'omitnan')

otherwise, this produces the same result:

N = mean(A(~isnan(A)))

[Alexandra Brian]

That worked! But why? There was no Nan information in my spreadsheet.

[Star Strider]

If I remember correctly, blank and other non-numeric spreadsheet cells become NaN values in the numeric data output from xlsread.

[Alexandra Brian]

Thank you Star Strider!

[Star Strider]

As always, my pleasure!