I need a little help with two array formulas. I would like to sum amounts based on: start/end dates, salesman, and product. Since a picture = 1K words I thought it best just to show what I need instead of trying to describe it in detail.
I only said there theres probably a better way i just through the answer quickly. It is a bit of a contrived function i provided manipulating the data, to provide an answer rather than providing an answer for the, ill have a think and see if i can come up with a better way. or someone else might.
Originally Posted by dejavu1313
Also, can you breakdown the "sumproduct(--" part of your code in layman terms?
sumproduct basically multiplies arrays together,
(--(A2:A7>J2) basically says get an array of boolean(TRUE OR FALSE) providing on the situation, the -- basically turns this array from True to 1 and False to 0 so we basicall build up a set of equations, and it multiplies accross the rows and adds these totals of each row together, Hence the SUM of the PRODUCTS