Excel formula question

[bearintex]

Wow, I'm way out of practice.

Here's the layout- 200 columns wide. 270 rows deep. The columns correspond to a judge. The rows are entrants in a car show, grouped by decade. Each judge will select their choice for a decade best, and will also select a choice for overall best of show (BOS). The BOS entry will be input per judge in row 1. I want to come up with a formula to count the number of times a number (corresponding to an entrant number in the adjacent cell) appears in row 1. I am pretty sure it is a countif function, but I can't make it work.

Here's a screenshot:



I want the red cell to calculate the number of times the value of the green cell appears in the range of light blue cells.

[hellbndr23]

I think your range for the countif function has to be a column like H2:H43. not a row.
I can try it in the morning when I get to work. No excel on the laptop yet.

[blacksunshine]

I think your range for the countif function has to be a column like H2:H43. not a row.
I can try it in the morning when I get to work. No excel on the laptop yet.

openoffice.org or even google docs

[hellbndr23]

I am DLing open office as we speak.

[Br'er_Henry]

=COUNTIF(H2:XX2;F4)

where XX2 is where your range ends