| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula Question
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
