Excel formula help please

[dastidlydaschel]

Could anyone tell me how to do a formula that does this....

Column A contains a list of numbers

Columns B C DE contain other information (names etc)

I need to create a formula in column F that automatically tells how many times the number on the same row features in column A

For example. There are 20 rows of data. The number 4578 features 4 times on column A in cells A2 A6 A15 A20. I need cells F2 F6 F15 and F20 to all tell me the result in this case is 4

Any help appreciated

=COUNTIF(A2,"4578")

Off the top of my head, anyhow. COUNTIFS would have the next value (if you wanted to check if there was 4578 or 5789 in the column in question), separated by a comma "4578","5789".

What if I don't know what the number is yet in column A?

You can use COUNTIF function in excel as suggested by previous post.

Countif(b2:e2, a2)

Then drag the formula down for the other rows and the row number (2) will update for the corresponding row.

Oops sorry, the range would be A2:A20

It will need to be

=COUNTIF($A$1:$A$20, $A2)

In order for the selected range to stay the same when you drag the formula down. Assuming your data starts at A1 and finishes at A20.