SUMPRODUCT
Nope.
=sumproduct(--(sheet2!a1:a10=a1),--(sheet2!c1:c10=c1),sheet2!d1:d10)
should return the same as:
=sumproduct(--(sheet2!c1:c10=c1),--(sheet2!a1:a10=a1),sheet2!d1:d10)
and
=sumproduct(sheet2!d1:d10,--(sheet2!c1:c10=c1),--(sheet2!a1:a10=a1))
(well, if I fixed each formula ok <vbg.)
Kigol wrote:
Does the order of columns matter in SUMPRODUCT as it does in LOOKUP
functions? ie: If I had data in Column J to sum, but the two criterion
were in columns K and M, would if affect the outcome at all?
--
Dave Peterson
|