How to add number of cells in a column and not the values in that cells?

2015 2 5
1 个回答
回答已采纳
更新时间：2015 2 8
7 次查看（30 天）

0 个投票

I have a file with single column and 365 rows. The file is attached with this. I have to check the data stored in each cell whether it is <=0 or not. If the data stored in cell is <=0, I have to count that total number of cells (not the addition of values in those cells) and store it in any variable. Kindly, help me regarding this.
Thanks & Regards

请先登录，再回答此问题。

 采纳的回答

Hikaru
Hikaru 2015-2-5

0 个投票

V = xlsread('Book1.xlsx');
c = V <= 0; % check the condition
ans = sum (c) % count total number of cells

2 个评论
显示 无 隐藏 无

Gargi
Gargi 2015-2-8
Sir, one more query is there.....if I want to check only first thirty data whether it is greater <=0, and count the cells and again the next thirty, then how it will be done? I've prepared the program like this but not working, please help me
A=xlsread('tb.xls','sheet1'); i=1:365; %total number of rows j=1:1; % total number of column A(i,j)=1; % first cell of the sheet while (A(i,j)<=30) %no.of cells <=30 c = A(i,j) >= 0; % condition for checking data in each cell total = sum (c); % total number of cells A(i,j)=A(i,j)+30; % loop for the next 30 data end
Thanks & Regards

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Acoustics, Noise and Vibration 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by