It only gave me a "0". When I know for the criteria there should be 282
Birdies. I really appreciate the help!

"Peo Sjoblom" wrote:

Try

=SUMPRODUCT(--(D3:D808=D2-1),--(A3:A808=A1),--(B3:B808A2),--(B3:B808<BA3))

--


Regards,


Peo Sjoblom

"JLewis" wrote in message
...
Okay, this works great for criteria that references the data I'm counting.
What about criteria based on another column? I have columns for division,
rating, name, and for holes 1-18. I also have the first row that gives the
hole pars. I have a formula for reporting birdies, bogeys, etc. But I'd
like
to more criteria to filter the data. Here is what I have in mind, but it
will
not work.
=COUNTIFS(D3:D808,D2-1,A3:A808,"="&A1,B3:B808,""&A2,B3:B808,"<"&BA3
"D2-1" references the par for the hole less one. Essentially a birdie.
A1,A2,A3 cells are for defining the filter criteria. This should give me
all
of the birdies for the players' scores that fit the criteria, shouldn't
it? I
like how you used the formula for being able to use an earlier form of
Excel.
I don't know that it would be necessary, but it is still nice to know that
I
could.

"Peo Sjoblom" wrote:

Yes it would, however I would rather
use this instead

=SUMPRODUCT(--(F3:F203A1),--(F3:F203<A2))


since it is compatible with earlier versions


--


Regards,


Peo Sjoblom