Formulas required for a certain number.

[hotrod]

I need formulas to calculate how may times a certain number (eg 5) appears in a column, row and table please. Or is there a formula that fits all three.
Thanks

 

[Peter_SSs]

Like this?

Column:
=COUNTIF(A:A,5)

Row:
=COUNTIF(1:1,5)

Table:
=COUNTIF(A1:E5,5)

 

[Richard Schollar]

Hi

Is each 5 in its own discrete cell or is it part of a string/number within cells? If the former then use COUNITF:

=COUNTIF(Range,5)

 

[jim may]

=COUNTIF(F:F,5) For Column
=COUNTIF(2:2,5) For Row
=COUNTIF(H14:J16,5) For Table

 

[hotrod]

Too easy, I should have know that.
Thank you gentlemen.