Sumproduct Error

  • Thread starter Thread starter AussieBec
  • Start date Start date
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
 
Par: =SUMPRODUCT(--($D$3:$F$3-D4:F4=0))
Birdie: =SUMPRODUCT(--($D$3:$F$3-D4:F4=1))

etc.
 
Thank you for this, it's taught me to look a different way of formulating my
formulas...
 
Back
Top