Excel Help (COUNTIF)

[tpreece01]

I have a table with two columns. How can I create a formula to add up how many times Colin scored more than 4 points?

Name Score
Colin 5
Colin 3
Adam 6 etc...

Thanks for any help.

[Davethedog]

"=COUNTIF(Range(ie A1):Range (ieA!)),">4")

[Davethedog]

Sorry wrong didn't read it properly

[Davethedog]

Right try again

In a third column in the adjacent cells put this

"=IF(C1="colin",D1," ") Where C1 is the name and D1 is the value.

You solud then get a column with just Colins values in.

Then "=COUNTIF(D1:D8,">4")

You can of course put this formula in any cell/column you can then hide coulmn 3 so it looks as though it is using column 2 as the base.