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