Sumproduct Erro
 

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

Sumproduct Erro
 

See response in public.excel

--

HTH

Bob

"AussieBec" wrote in message
...
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

Sumproduct Erro
 

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))
--
David Biddulph


"AussieBec" wrote in message
...
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