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
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.
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.