Thread: array formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default 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!