1. >a <- array(rep(1:3, each=3), dim=c(3,3))
2. >a
3. >rowSums(a)
4. [1] 6 6 6
5. >colSums(a)
6. [1] 3 6 9
7. >table(a)
=COUNTIFS(E:E,">=20",E:E,"<=40")
=COUNTIFS(E:E,">=41",E:E,"<=60")
=COUNTIF(E:E,">60")
1. >a <- array(rep(1:3, each=3), dim=c(3,3))
2. >a
3. >rowSums(a)
4. [1] 6 6 6
5. >colSums(a)
6. [1] 3 6 9
7. >table(a)
=COUNTIFS(E:E,">=20",E:E,"<=40")
=COUNTIFS(E:E,">=41",E:E,"<=60")
=COUNTIF(E:E,">60")