Forum Discussion
Solved
A neater way to summarise daily sales data?
I've created a 'monthly sales' workbook, listing individual line items from orders. Data comes straight from a Magento 'order export' function.
I'm taking each line item and summing onto a sepa...
Hi Stefan,
Could be
=SUMPRODUCT((INT(tblData[Date & Time])=tblRegularCash[@Date])*(tblData[Charged £]))
That's regular, not array formula
Hi Stefan,
Could be
=SUMPRODUCT((INT(tblData[Date & Time])=tblRegularCash[@Date])*(tblData[Charged £]))
That's regular, not array formula
I've now replaced each array formula with the equivalent =SUMPRODUCT() as well as replacing the DAY(),MONTH(),YEAR() triple with an INT(<date>).
Much tidier and simpler to understand from first glance. Again, thankyou.Hi Stefan,
You are welcome. Usually I also prefer regular formula if alternative to array one exists.
- Thankyou, Sergei. That's a much neater solution. Appreciate your help.
I'm not a huge fan of working with array formula, but it has solved a number of situations for me over the years.
I shall spend some time looking at ways of replacing them with regular functions. Thanks again.
