| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct and Array Formula
Hi,
I have an Array formula which is entered with CTRL + SHIFT + ENTER. I'm wondering if I can achieve the same result with a Sumproduct formula or something else. The array Formula I have is as follows: {=SUM(IF((July!$B$11:July!$B$2000)*(July!$F$11:Ju ly!$F$200=July!$BK$12)*(July!$K$11:July!$K$200=Jul y!AV11)*(July!$G$11:July!$G$200=0),July!$AK$11:Jul y!$AK$200))} |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Possible Array or Sumproduct Formula | Excel Worksheet Functions | |||
| Array formula for SUMPRODUCT | Excel Worksheet Functions | |||
| Baseball sumproduct/array formula? | Excel Worksheet Functions | |||
| do I need array formula or sumproduct for counting? | Excel Worksheet Functions | |||
| SUMPRODUCT as array formula? | Excel Worksheet Functions | |||
Threaded Mode
