Thread: Sumproduct Erro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AussieBec AussieBec is offline
external usenet poster
 
Posts: 14
Default 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