ExcelBanter - countif when the criteria is a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif when the criteria is a formula (https://www.excelbanter.com/excel-worksheet-functions/224031-countif-when-criteria-formula.html)

Nestor[_2_]

countif when the criteria is a formula

On col A1toA100 have number,from col B10 have the averages of last 10 numbers
AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10").
Can anyone help?
Nestor

Gary''s Student

countif when the criteria is a formula

=COUNTIF(A1:A10,"<" & B10)

for example, from A1 thru C20:

29
29
24
23
13
24
28
8
13
25 21.6 3
16 20.3 4
15 18.9 5
5 17 6
23 17 6
28 18.5 5
14 17.5 6
7 15.4 6
30 17.6 6
21 18.4 5
20 17.9 5

--
Gary''s Student - gsnu200838

"Nestor" wrote:

On col A1toA100 have number,from col B10 have the averages of last 10 numbers
AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10").
Can anyone help?
Nestor

Stefi

countif when the criteria is a formula

=COUNTIF(A1:A10,""&B10)

Regards,
Stefi

€žNestor€ ezt Ã*rta:

On col A1toA100 have number,from col B10 have the averages of last 10 numbers
AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10").
Can anyone help?
Nestor

All times are GMT +1. The time now is 10:43 AM.