Sumproduct Error

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
 
B

Bob Phillips

Par: =SUMPRODUCT(--($D$3:$F$3-D4:F4=0))
Birdie: =SUMPRODUCT(--($D$3:$F$3-D4:F4=1))

etc.
 
A

AussieBec

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top