Array Formula Question
Condition Count
=COUNT(IF(J2:J2000=E8,IF(K2:K2000=E9,M2:M2000)))
=COUNT(IF(J2:J2000=E8,IF(K2:K2000=E9,1)))
=SUM(IF(J2:J2000=E8,IF(K2:K2000=E9,1)))
Ctrl+Shift+Enter
Condition Max
=MAX(IF(J2:J2000=E8),IF(K2:K2000=E9,M2:M2000)))
Ctrl+Shift+Enter
On Mar 10, 4:42 am, IPerlovsky wrote:
I am receiving "the formula you typed contains an error" when I try to
execute the following formulas. Any ideas why these don't work?
=COUNTIF((--(J2:J2000=E8),--(K2:K2000=E9)),M2:M2000)
=MAX(IF((--(J2:J2000=E8),--(K2:K2000=E9)),M2:M2000)))
when this one does...
=SUMPRODUCT(--(J2:J2000=E8),--(K2:K2000=E9),M2:M2000)
--
iperlovsky
|