The reason I ask about the other 2 formulas is because I am receiving "the
formula you typed contains an error" when I try to execute them. Any idea
why?
--
iperlovsky


"Bob Phillips" wrote:



"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.