A
AussieBec
Why am I not getting the right result with the below formula?
Col/row D E F
2 type hole1 hole2 hole3 hole4
3 par 4 4 3 5
4 0 4 5 4 7
=SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4))
My aim is to count how many times I par or birdie a hole in a round of golf.
This result returns zero not 1.
TIA
Bec
Col/row D E F
2 type hole1 hole2 hole3 hole4
3 par 4 4 3 5
4 0 4 5 4 7
=SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4))
My aim is to count how many times I par or birdie a hole in a round of golf.
This result returns zero not 1.
TIA
Bec