"IPerlovsky" wrote in message
...
Thank you. I modified it slightly for simplicity as:

=SUMPRODUCT(--(J2:J2000=E8),--(K2:K2000=E9),M2:M2000)

How would I employ that methodoligy in the following 2 formulas so that it
would:
countif, based on 2 criterion...

=COUNTIF(--((J2:J2000=E8),--(K2:K2000=E9)),E8)


=SUMPRODUCT(--(J2:J2000=E8),--(K2:K2000=E9))


and max(if, based on 2 criterion...

=MAX(IF(--((J2:J2000=E8),--(K2:K2000=E9)),M2:M2000)))


Exactly that, but as an array formula, so commit with Ctrl-Shift-Enter, not
just Enter.