ExcelBanter - Formatting mark 2

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting mark 2 (https://www.excelbanter.com/excel-discussion-misc-queries/151628-formatting-mark-2-a.html)

Formatting mark 2

I have a range of cells say A1 to A5 and A6:A8 that can have the numbers 1,
2, or 3 in
them.

In cell B1 I want to display the total number of cells in range A1:A5 and
A6:A8 that
have a 1 in
In cell C1 I want to display the total number of cells in range A1:A5 and
A6:A8 that
have a 2 in
In cell D1 I want to display the total number of cells in range A1:A5 and
A6:A8 that
have a 3 in

How do I do it ?

Thanks

Formatting mark 2

=countif(a1:a8,1)

this is a contiguous range (a1:a5, a6:a8 = a1:a8)

"Andy_Trow" wrote:

I have a range of cells say A1 to A5 and A6:A8 that can have the numbers 1,
2, or 3 in
them.

In cell B1 I want to display the total number of cells in range A1:A5 and
A6:A8 that
have a 1 in
In cell C1 I want to display the total number of cells in range A1:A5 and
A6:A8 that
have a 2 in
In cell D1 I want to display the total number of cells in range A1:A5 and
A6:A8 that
have a 3 in

How do I do it ?

Thanks