B
Bernard Liengme
In A1:A10, enter a letter in each: a, b, c, x, y, z. a, b, c, a
In B1 enter =COUNTIF(A1:A10,"a") this will return a count of how man 'c'
values in A1A:10
So will =COUNTIFS(A1:A10,"a")
In D1
10 enter some values: 4, 5, 6, 7, 8, 5, 7, 8. 9, 3
In E1 =COUNTIF(D110,">=5") returns how many have values of 5 or more
in E2 enter 5
In E3 =COUNTIF(D110,">="&E2) returns how many have values equal or more
than value in E2
In F1 =COUNTIF(a1:a10,"c",B1:B10,5) count how many row have c in columne A
and 5 in column B
Now experiment !
best wishes
In B1 enter =COUNTIF(A1:A10,"a") this will return a count of how man 'c'
values in A1A:10
So will =COUNTIFS(A1:A10,"a")
In D1
10 enter some values: 4, 5, 6, 7, 8, 5, 7, 8. 9, 3In E1 =COUNTIF(D1
10,">=5") returns how many have values of 5 or morein E2 enter 5
In E3 =COUNTIF(D1
10,">="&E2) returns how many have values equal or morethan value in E2
In F1 =COUNTIF(a1:a10,"c",B1:B10,5) count how many row have c in columne A
and 5 in column B
Now experiment !
best wishes