ExcelBanter - count only certain cells

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

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

- - count only certain cells (https://www.excelbanter.com/excel-worksheet-functions/190904-count-only-certain-cells.html)

Robert-Alpha[_2_]

count only certain cells

how do i count only cells with a specific value in it...for ex., in the list
below i only want to count the cells with number 4 in them.. =3
4
4
4
5
5
5
2
2

PCLIVE

count only certain cells

=COUNTIF(A1:A10,4)

Regards,
Paul

--

"Robert-Alpha" wrote in message
...
how do i count only cells with a specific value in it...for ex., in the
list
below i only want to count the cells with number 4 in them.. =3
4
4
4
5
5
5
2
2

Mike H

count only certain cells

Maybe

=COUNTIF(A1:A11,4)

Mike

"Robert-Alpha" wrote:

how do i count only cells with a specific value in it...for ex., in the list
below i only want to count the cells with number 4 in them.. =3
4
4
4
5
5
5
2
2

All times are GMT +1. The time now is 03:02 PM.