Formatting mark 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top