Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
array formulas
I'm a liitle confused about the difference between "regular" formulas and
array formulas. For example, I'm using "SUMPRODUCT" with 2 criteria to sum values. I am getting the correct sum, even though I don't have the array brackets in my formula. Any help would be useful! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
array formulas
I am getting the correct sum, even though
I don't have the array brackets in my formula. SUMPRODUCT doesn't need to be array-entered, that's why <g. And that's one of its strengths ! (Think there could be exceptions though, for eg: where TRANSPOSE is used within the SUMPRODUCT) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave" wrote in message ... I'm a liitle confused about the difference between "regular" formulas and array formulas. For example, I'm using "SUMPRODUCT" with 2 criteria to sum values. I am getting the correct sum, even though I don't have the array brackets in my formula. Any help would be useful! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
array formulas
Dave,
SUMPRODUCT works with array already, and doesn't need to be array-entered. The array handling ability is built-in to SUMPRODUCT natively. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Dave" wrote in message ... I'm a liitle confused about the difference between "regular" formulas and array formulas. For example, I'm using "SUMPRODUCT" with 2 criteria to sum values. I am getting the correct sum, even though I don't have the array brackets in my formula. Any help would be useful! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
array formulas | Excel Worksheet Functions | |||
array formulas | Excel Worksheet Functions |