Sumproduct Erro

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
 
D

David Biddulph

In your formula E3<>E4 and F3<>F4 so you are multiplying 1 by 0 by 0, so the
answer is 0.

Perhaps you intended =SUMPRODUCT(--(D3:F3=D4:F4)) ?

But note also that you are counting pars, not birdies. If you want to count
birdies, try =SUMPRODUCT(--(D3:F3=D4:F4+1))
 
Top