Any clever Excel users here?

eta said:

i'm reasonable good at excel and often answer questions on the excels forums, which maybe better place to go
say -
https://www.excelforum.com/
where you can easily load a sample

ANY way
COUNTIF should work
Assuming the PAR is in ROW 1 - and starts at B2 to S2 - although you may have a column for 1st half after 9 holes

{=SUM(N(headerange=columnname)*N(datarange>0))}
use control+shift+ enter to get the { brackets
if you Rows go up to row 10
And the PAR are in row 1
then
=SUM(N(B1:S1=B2:S10)*N(B2:S10>0))}
Dont need the N function
=SUM((B2:T2=B4:T20)*(B4:T20>0))

i'll try a sample sheet for you
Cant load a XL file, not sure if zip allowed
https://www.dropbox.com/s/a9r6vgoupjoh66p/GolfPar.xlsx?dl=0

Click to expand...

WabbitPoo said:

Simple task: I have a spreadsheet for my golf scores. Along the top I have the par for the hole, then a row for each round. I wish to count the number of par scores on each round.

So I thought I could use COUNTIF(range, criteria) but the criteria only seems to allow me to compare to a specific value or one particular cell.

Ideas?

Click to expand...