I think I am looking for a relatively simple countif output, but stuggling to type it up...
Basically I've got a load of football results in neighbouring columns: Home score | Away score | Home score | Away score | Home score | Away score | etc... (B6 | C6 | D6 | E6 etc...)
I want to report in a column at the end the number of times the Home Score is Greater than the Away Score (and Vice Versa)...
My Header Row (A5:D5 above the scores) are numbered alternating 5 | 6 | 5 | 6..
So I'm trying to input a formula which looks to see if the values in the columns headed 5 are greater than their neighbours, headed 6...
Does this need an Array Formula - something like this??
{COUNTIF(A6:D6,((A5:D5=5)>(A5:D5=6)))} ???
JP
Basically I've got a load of football results in neighbouring columns: Home score | Away score | Home score | Away score | Home score | Away score | etc... (B6 | C6 | D6 | E6 etc...)
I want to report in a column at the end the number of times the Home Score is Greater than the Away Score (and Vice Versa)...
My Header Row (A5:D5 above the scores) are numbered alternating 5 | 6 | 5 | 6..
So I'm trying to input a formula which looks to see if the values in the columns headed 5 are greater than their neighbours, headed 6...
Does this need an Array Formula - something like this??
{COUNTIF(A6:D6,((A5:D5=5)>(A5:D5=6)))} ???
JP