How to add number of cells in a column and not the values in that cells?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
0 commentaires
Réponse acceptée
Hikaru
le 5 Fév 2015
V = xlsread('Book1.xlsx');
c = V <= 0; % check the condition
ans = sum (c) % count total number of cells
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Shifting and Sorting Matrices dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!