A
AussieBec
Not sure why I get an error here...
D E F
2 type hole1 hole2 hole3
3 par 4 4 3
4 0 4 5 4
I want to count how many time I either get a par or birdie in a round of golf.
=SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4))
This returns a 0 result.
TIA
Bec
D E F
2 type hole1 hole2 hole3
3 par 4 4 3
4 0 4 5 4
I want to count how many time I either get a par or birdie in a round of golf.
=SUMPRODUCT(--($D$3=D4),--($E$3=E4),--($F$3=$F$4))
This returns a 0 result.
TIA
Bec