| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array, Formula, Constant, IF Statement Question???? | Excel Discussion (Misc queries) | |||
| Array Question | Excel Discussion (Misc queries) | |||
| Formula/Array question with dates | Excel Worksheet Functions | |||
| Multicell Array Formula and List Question | Excel Worksheet Functions | |||
| SUM array formula question | Excel Worksheet Functions | |||
Threaded Mode
